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

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

Avatar

Level 1

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?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

So I assume you are looking at something like:

Jennifer_Dungan_0-1665515535872.png

or

Jennifer_Dungan_1-1665515572494.png

 

 

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":

Jennifer_Dungan_2-1665515695928.png

 

(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:

Jennifer_Dungan_3-1665515820251.png

 

or

 

Jennifer_Dungan_4-1665515827963.png

 

 

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

Jennifer_Dungan_5-1665515899541.png

 

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

 

View solution in original post

3 Replies

Avatar

Correct answer by
Community Advisor

So I assume you are looking at something like:

Jennifer_Dungan_0-1665515535872.png

or

Jennifer_Dungan_1-1665515572494.png

 

 

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":

Jennifer_Dungan_2-1665515695928.png

 

(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:

Jennifer_Dungan_3-1665515820251.png

 

or

 

Jennifer_Dungan_4-1665515827963.png

 

 

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

Jennifer_Dungan_5-1665515899541.png

 

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