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.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive