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.
Let me know if this is possible.
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.
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. 😅