Year over Year trend analysis, where current year does not drop to 0 for remainder of year | Community
Skip to main content
October 11, 2022
Solved

Year over Year trend analysis, where current year does not drop to 0 for remainder of year

  • October 11, 2022
  • 1 reply
  • 1232 views

I am trying to set up a year over year comparison of Visits. With the dimension either being Week or Month, I want to show, for example all of 2021, but then for 2022, rather than the line dropping to 0 for November and December, is there a way that the line just ends at where it currently is, so we don't see a huge drop until time catches up?

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 Jennifer_Dungan

So I assume you are looking at something like:

or

 

 

Where the current partial month looks really bad by comparison.

 

 

You can use a little trick to create a segment that will exclude traffic from "this month":

 

(Notice the entire segment is an exclude rule - and you can change the metric to something more appropriate for your graph)

 

You can apply to the panel, or to the "current year column" in your data table, and it will result in:

 

or

 

 

 

Notice that all the data from this month (October) is removed. I also made sure to "interpret zero as no value":

 

Now, October's data will only show up once it's Nov 1, and November will then be hidden.

 

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
October 11, 2022

So I assume you are looking at something like:

or

 

 

Where the current partial month looks really bad by comparison.

 

 

You can use a little trick to create a segment that will exclude traffic from "this month":

 

(Notice the entire segment is an exclude rule - and you can change the metric to something more appropriate for your graph)

 

You can apply to the panel, or to the "current year column" in your data table, and it will result in:

 

or

 

 

 

Notice that all the data from this month (October) is removed. I also made sure to "interpret zero as no value":

 

Now, October's data will only show up once it's Nov 1, and November will then be hidden.

 

October 11, 2022

Brilliant!!! Thank you so much!

 

Jennifer_Dungan
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
October 11, 2022

You're very welcome! Glad I could help.