To Date Period over Period Cards - Flawed due to leap year?

JasonAltenburg
Contributor

in Charting
When using the "to Date" cards, with a daily date grain, I'm noticing they show variance spikes due to shifting the dates 1 day, regardless of selecting YoY or 52 weeks as the comparison to, and I think this is due to the Leap Year. Another way to explain it is that the "align by day of week" option is aligning Mondays for 2020 with Sundays for 2019.
It seems like other Date Ranges are not impacted by this, but it makes the "to Date" cards somewhat unusable.
Is this a known issue, or is it an "undocumented feature"?
Tagged:
0
Comments
-
I'll typically do a comparison to 364 (364 / 7 = 52) days ago so that the same days are compared against each other (Sunday - Sunday, Monday - Monday etc) which tends to get around this issue.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
This discussion has been closed.
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 434 Beast Mode
- 22 Variables
- 511 Automate
- 114 Apps
- 389 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive