Comparing odd date ranges | Community
Skip to main content
May 26, 2017
Solved

Comparing odd date ranges

  • May 26, 2017
  • 1 reply
  • 845 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by TanmayMathur

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.html

Thanks,

Tanmay

1 reply

TanmayMathur
Adobe Employee
TanmayMathurAdobe EmployeeAccepted solution
Adobe Employee
May 29, 2017

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.html

Thanks,

Tanmay