Custom YOY Seasonal Calendar year

My company runs events twice a year, Spring and Winter.
However, these events do not start on the same day every year.
I am looking for a way to do Custom YOY dates in the cards so that I can compare this year with last year or the year before without needing to calculate each year's comparison data into each row using the ETL.
I would like to compare that automatically to a specific date last year instead of using the generic YOY provided in Analyzer.
I have a table with the specific dates. Wondering how to achieve this since my company is seasonal and each event is spaced apart differently and not always starting on the same day.
We would want to compare Winter to Winter and Spring to Spring.
I'm ok to code if required, just need to know where to begin.
Best Answer
-
Because how Domo processes data (row-based) and your need to have custom date offsets you'd need to utilize an ETL to process your data. Instead of using the date from 1 year ago to join on you can use the event and the year (this year event) = last year (last years event). This would allow you to compare the custom date offset YoY calculation.
https://community-forums.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
Because how Domo processes data (row-based) and your need to have custom date offsets you'd need to utilize an ETL to process your data. Instead of using the date from 1 year ago to join on you can use the event and the year (this year event) = last year (last years event). This would allow you to compare the custom date offset YoY calculation.
https://community-forums.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 306 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 112 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 787 Beast Mode
- 78 App Studio
- 43 Variables
- 743 Automate
- 187 Apps
- 474 APIs & Domo Developer
- 67 Workflows
- 15 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 139 Manage
- 136 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive