FISCAL calendar period over period comparison to previous years
Hi,
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.
Comments
-
build a fiscal calendar where for each day you assign the week the date belongs to.
if you can imagine, every company would have a slightly different take on what the week number should be, so having an artifact in a table
1) guarantees that you can see it
2) creates a column you can filter any dataset with.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive