Dynamic YoY date range based on date selection | Community
Skip to main content
A
arghode
April 13, 2022
Solved

Dynamic YoY date range based on date selection

  • April 13, 2022
  • 1 reply
  • 769 views

Hello !
I want to compare my KPI's YoY based on the date selected in the workspace.

Example: The date in the workspace is selected as 1st march 2022- 31st march 2022 then the comparison date should be 1st march 2021 -31st march 2021. Now, in the same report I change the date range to 1st feb 2022-31st march 2022 then the comparison date should change to 1st feb 2021-31st march 2021.
@pratheeparunraj 
Let me know if this is possible.
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 jeff_bloomer

Yes, unfortunately, this is so common.  I just spent an entire hour on the phone the other day with @derek-tangren  from Adobe talking about this very thing.  The very first thing I would be doing is creating a YoY Date Range, and believe it or not, you can actually drag and drop them as Filters/Segments.  It's a real time saver.

Anyway, shedding some light on this one since I literally just had this conversation last week.  😅

1 reply

Pablo_Childe
Community Advisor
Pablo_ChildeCommunity Advisor
Community Advisor
April 13, 2022

Sadly no out of box YoY like the reporting GUI allows.

You would need to add a new custom date segment. 

 

So as an example:

row 1    Last month March 2022     (custom segment)12 mths ago March 2021.

 

As soon as you change date though you would need to add new segment for new 12 mths ago...

 

Definitely a feature enhancement needed here since reporting GUI is being depreciated.

    jeff_bloomer
    Community Advisor and Adobe Champion
    jeff_bloomerCommunity Advisor and Adobe ChampionAccepted solution
    Community Advisor and Adobe Champion
    April 18, 2022

    Yes, unfortunately, this is so common.  I just spent an entire hour on the phone the other day with @derek-tangren  from Adobe talking about this very thing.  The very first thing I would be doing is creating a YoY Date Range, and believe it or not, you can actually drag and drop them as Filters/Segments.  It's a real time saver.

    Anyway, shedding some light on this one since I literally just had this conversation last week.  😅

      Terms & ConditionsAccessibility statement

      Loading footer...