YOY reporting based on Fiscal Week
Can we create a YOY card similar like this
But based on the date range selected 10/20 to 10/26 which is fiscal week 43. It should compare the previous year fiscal week 43 which is date range 10/22 to 10/28. Currently, what is doing is it is comparing the same date range for 2023 (10/20/2023 to 10/26/2023).
Is it possible to do in Domo in this view.
Answers
-
Creating a Year-Over-Year (YOY) card that compares fiscal weeks, rather than calendar dates, requires some custom adjustments because the default behavior will match the same calendar dates across years, not the same fiscal weeks.
Make sure your dataset has a field for the fiscal week and year. This allows you to create a calculated field that maps each date to the correct fiscal week in both the current and previous years. Then a calculated field something like
CASE
WHEN `Year` = YEAR(CURRENT_DATE()) THEN `Value`
WHEN `Year` = YEAR(CURRENT_DATE()) - 1 AND `FiscalWeek` = <CurrentFiscalWeek> THEN `Value`
END** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
@scpradhan There is a feature called Fiscal Calendar that you can use to filter and compare dates based on your company calendar. If you haven't already I'd recommend reaching out to your account team to get one enabled.
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 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
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 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
- 108 Community Announcements
- 4.8K Archive