How can I compare YOY data with an offset of a couple of days?
Hello,
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!
Answers
-
I would suggest you look at this youtube video by @jaeW_at_Onyx who walks through building an offset date table which would allow you to do what you want. In his example, he is building date dimension table for the exact day a year earlier, but you could make yours different so that it you can compare the dates you want for Memorial Day.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.1 -
Thanks for the mention @MarkSnodgrass .
If it were me, I'd create a table with two columns. Date and PromotionTitle.
Then JOIN that dataset to your transactions. Then use CASE statements to compare PromotionTitle = BlackFriday2017 and BlackFriday2018.
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.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive