Level 5

Solved

Pre/Post Analysis

8 replies
1414 views
Translate All

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!

Analytics

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

MandyGeorgeAccepted solution

Adobe Champion, Community Advisor, UG Leader

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.

Isha Gupta

Adobe Champion, Community Advisor, UG Leader

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

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

Translate

skatofiabahAuthor

Level 5

Hi @isha__gupta

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.

Translate

Isha Gupta

Adobe Champion, Community Advisor, UG Leader

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-

Translate

MandyGeorge

Accepted solution

Adobe Champion, Community Advisor, UG Leader

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.

Translate

Jennifer_Dungan

Adobe Champion and Community Advisor

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

Translate

Sign up

Login with SSO

Login to the community

Login with SSO