Trend Year over Year

[andrea0313]

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.

[TanmayMathur · Accepted solution]

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

[Linda58]

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?? 

[JJamnik]

One way to do this is to create custom metrics for YoY variance, then create a table with that metric against Month of Year. This video is helpful for creating the date segments and metrics: Growth Rates. Adobe Analytics Workspace Training (2018) - Part 4 - YouTube

[gitaib92245504]

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.

[HaiTechEric]

I found this solution worked great for me:

https://marketing.adobe.com/resources/help/en_US/analytics/analysis-workspace/time_comparison.html

[debg46628983]

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.