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!