Period over Period - Month to Date - Weekday comparison
Hello,
I am trying to create a multiple series, period over period chart on a Month to date basis. I want to create a chart that shows Revenue and Jobs comparison on a weekday basis where this year vs previous year.
For example a chart that shows October Month to date weekday comparison like Oct 1st 2020 is a Thursday and would like to compare with Thursday Oct 3rd 2019. This year 2020 being a leap year throws a problem and not sure how to do it.
Can someone help me with the weekday comparison please.
Thanks in advance!!
Comments
-
Hi @user011045
I've done a previous write up regarding customized period over period data models. You can refer to https://dojo.domo.com/t5/Card-Building/show-percent-on-period-over-period-graph/m-p/50540/highlight/true#M7313 for an in dept description of what needs to happen.
You'd join the table together against your date comparison dimension table and filter your card based on the comparison type ('Last Year (DOW Aligned)')
The key point on getting your dates to line up Year over Year is to subtract 364 days (evenly divisible by 7) so that each day of the week matches as closely to the same day of the week a year ago. It's documented in the example SQL as 'Last Year (DOW Aligned)'
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive