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

Trend Year over Year

andrea0313
Level 2
Level 2

I cannot seem to figure out how to trend year over year by month in the workspace. I'm just trying to get our key metrics (unique visitors, visits) for this year to date by month and then how that compares to last year the same time. Should I just do two freeform tables next to each other? seems odd that this is not an easy option unless I am completely missing it.

 

UPDATE: based on a post I discovered by accident from November it sounds like this is still on the docket for improvements. I'm kind of shocked it was pushed without this. I really thought I was just missing something.

1 Accepted Solution
TanmayMathur
Correct answer by
Level 10
Level 10

Hi Andrea, 

Have you been able to create the comparison in workspace? 

For a comparing trended reports like the key metrics report you would have to create 2 different freeform tables and use different date ranges. For comparing a ranked report like a pages report you would simply have to add the metrics/dimension twice in the freeform table and apply the date range on individual columns. 

Let me know if this helps you.

Tanmay

View solution in original post

5 Replies
TanmayMathur
Correct answer by
Level 10
Level 10

Hi Andrea, 

Have you been able to create the comparison in workspace? 

For a comparing trended reports like the key metrics report you would have to create 2 different freeform tables and use different date ranges. For comparing a ranked report like a pages report you would simply have to add the metrics/dimension twice in the freeform table and apply the date range on individual columns. 

Let me know if this helps you.

Tanmay

View solution in original post

Linda58
Level 2
Level 2

You have got to be kidding me, this has been going on since 2016 and it is November of 2021 and it is not fixed yet?!?  We, as customers, have to do the same thing you were doing in 2016 for a work a around??? Really?? 

gitaib92245504
Level 2
Level 2

This isn't actually a great solution as there's real physical distance between the two. There's a compare option within Reports that should be available on on reports, not just custom traffic and conversion reports or when added to dashboards.

debg46628983
Level 2
Level 2

I can't get the Compare Time Periods feature to work at all.  I have a freeform table with a PageName value as the row, and Visits as the metric.  When I right click on the PageName value I don't see Compare Time Periods as an option.