Trend Year over Year | Community
Skip to main content
A
andrea0313
Level 1
April 28, 2016
Solved

Trend Year over Year

  • April 28, 2016
  • 4 replies
  • 8106 views

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.

    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 TanmayMathur

    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

    4 replies

    TanmayMathur
    Adobe Employee
    TanmayMathurAdobe EmployeeAccepted solution
    Adobe Employee
    May 17, 2016

    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

    L
    Linda58
    Level 3
    November 3, 2021

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

      J
      Adobe Champion
      JJamnik1Adobe Champion
      Adobe Champion
      November 15, 2022

      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
      gitaib92245504
      Level 2
      September 26, 2016

      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.

      H
      HaiTechEric
      Level 3
      February 11, 2017

      I found this solution worked great for me:

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

        D
        debgo
        Level 2
        April 16, 2018

        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.

        Terms & ConditionsAccessibility statement

        Loading footer...