Pre/Post Analysis | Community
Skip to main content
skatofiabah
skatofiabah
Level 5
November 6, 2024
Solved

Pre/Post Analysis

  • November 6, 2024
  • 3 replies
  • 1348 views

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!

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 MandyGeorge

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. 

3 replies

Isha Gupta
Community Advisor and Adobe Champion
Isha GuptaCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
November 6, 2024

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

 

    skatofiabah
    skatofiabahAuthor
    Level 5
    November 6, 2024

    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.

    Isha Gupta
    Community Advisor and Adobe Champion
    Isha GuptaCommunity Advisor and Adobe Champion
    Community Advisor and Adobe Champion
    November 6, 2024

    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-

     

     

      MandyGeorge
      Community Advisor and Adobe Champion
      MandyGeorgeCommunity Advisor and Adobe ChampionAccepted solution
      Community Advisor and Adobe Champion
      November 6, 2024

      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
        Community Advisor and Adobe Champion
        Jennifer_DunganCommunity Advisor and Adobe Champion
        Community Advisor and Adobe Champion
        November 7, 2024

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

          Terms & ConditionsAccessibility statement

          Loading footer...