Pre/Post Analysis

[skatofiabah]

Hi,

Is there a way to do a rolling pre/post time window to a given date? For Example, If I start a test Nov 1, I'd want my dates to be 5 in front (Nov 5.) and 5 behind (Oct 26). Can it roll forward and backwards?

Thanks!

[igupta]

You may consider using "Compare time Periods" option in the metric column.

https://experienceleague.adobe.com/en/docs/analytics/analyze/analysis-workspace/components/calendar-...

[skatofiabah]

Hi @igupta

The problem with this is that when the days change tomorrow, it won't update automatically. It won't let me pick "previous period" and have it be rolling outward.

[igupta]

Can you consider creating a date range with fixed start and rolling end? For example - Nov 5 - today or yesterday. For previous period, are you looking for fixed days? For previous period, you can keep end of as fixed day and start as rolling?

Current Period-

Previous Period-

[skatofiabah]

Hi @igupta,

I need it to roll back for the pre period. The start date needs to increase outwards each day that the end of post period increases a day.

[igupta]

Sorry but can you please provide example in terms of date range what you are looking for? And how you expect this to work?

[MandyGeorge]

@igupta The date ranges can't roll backwards currently, only forwards. So this isn't possible.

[MandyGeorge · Accepted solution]

There is a limitation with dates ranges when it comes to going backwards. You can go from a fixed date to the present date (rolling forwards), but you can't go from a fixed end with a rolling backwards start date. This is a feature that has been suggested to the product team or not, but we aren't sure if it's something they're going to implement eventually.

Even just using "compare time periods" - it will create a range with the same number of days based on when you create it. 

So, at present, no, what you want isn't possible. 

[Jennifer_Dungan]

Just to add an alternate solution...

@MandyGeorge is correct, you cannot do this in Adobe... but you can do it with Report Builder.

Not using Report Builder's preset date ranges, but if you use the "Dates from Cells" you can use Excel's date formulas to create the range logic you need.

Whenever I need more precise date logic, this is my go-to...