Pre/Post Analysis

Question

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!

MandyGeorge · Accepted Answer

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 · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO