Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Dynamic YoY date range based on date selection

Avatar

Level 1

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 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

0 Replies

Avatar

Community Advisor

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.

Avatar

Correct answer by
Community Advisor

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