How can I compare YOY data with an offset of a couple of days?
I'm 100% new to DOMO and I'm looking for some assistance.
I'm trying to compare data from 2021 against data from 2020 using DOMO with a dataset connected combining data from multiple Adobe Analytics sources, and other accounts. Specifically I need to compare promotional revenue data for a Memorial Day promotion.
I need to compare May 18th - June 7th 2021 to May 12th - June 1st 2020. I'm successfully able to compare the YOY data but I'm unable to account for the 6 day offset.
How can I create a comparative gauge that will show percent change in revenue between the 2 time periods that I've listed above?? Do I need to use a Beast Mode calculation or create a new dataset using Magic ETL that could help account for the offset?
My current dataset contains a Date column, as well as a column for Order Total LY and Order Total TY.
Thanks in advance!
- 7.3K All Categories
- 13 Getting Started in the Community
- 142 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 904 Connectors
- 237 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 235 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部