FISCAL calendar period over period comparison to previous years
On the POP charts with a FISCAL year configured for the instance the logic for comparing to previous years works by matching on the week and year number. e.g. Week 5 of 2022 compares to week 5 in 2021 and 2019.
Our customers don't compare like this. They prefer to just compare 1 FISCAL year ago so the logic would be Week 5 - 364 days for 2021 and Week 5 - 364-364 days for 2020
Due to the 53 week being present in some years the comparison week can be different between the two ways above.
The benefit of doing -364 is it will always compare week 53 to the previous year. Currently domo won't compare week 53 to anything so on yearly comparisons you can end up comparing 53 weeks against 52 and if last week happens to be a 53rd week it also won't compare to anything.
Being able to choose this logic would be great even if via a support request.
- 7.4K All Categories
- 13 Getting Started in the Community
- 150 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 905 Connectors
- 239 Workbench
- 343 APIs
- 77 Apps
- 19 Governance & Productivity
- 237 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部