Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

Comparing odd date ranges

Avatar

Level 1

We recently launched a product and I would like to compare the first 7 days after launch to the first 7 days after our last launch. The dates don't exactly line up so I'm having trouble comparing them. 

I'm in Workspace and want to have a line visualization where I can see Orders, as well as other metrics, from the two launches on top of each other (launch day, 2nd day and so on). If these were both launched on the same date (or day of the week) it would be simple to compare as I could use day of the week as a dimension and compare my two segments, but those dates don't line up. I would like to normalize the dates (Day1, Day2, Day3 etc.), but I'm having a lot of trouble doing this. 

Is there a simple way to do this? Surely I'm not the only person who has wanted to compare a set of dates that do not line up. 

Thanks in advance. 

Matt

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi Matt,

Welcome to the Analytics Community!

Have you tried create a custom date range? Looking at your scenario i think it should do the job. You can apply those date ranges to the order column and compare the data. You can set rolling date ranges as well. Click on '+New' on the side panel and then select 'Create date range'. Detailed steps are given here - https://marketing.adobe.com/resources/help/en_US/analytics/analysis-workspace/custom-date-ranges.htm...

Thanks,

Tanmay

View solution in original post

1 Reply

Avatar

Correct answer by
Level 10

Hi Matt,

Welcome to the Analytics Community!

Have you tried create a custom date range? Looking at your scenario i think it should do the job. You can apply those date ranges to the order column and compare the data. You can set rolling date ranges as well. Click on '+New' on the side panel and then select 'Create date range'. Detailed steps are given here - https://marketing.adobe.com/resources/help/en_US/analytics/analysis-workspace/custom-date-ranges.htm...

Thanks,

Tanmay