year over over comparison

jrubio
jrubio Member
in Magic ETL

I trying to build a line graph that is comparing previous years.  X axis is showing months y axis showing values

Best Answer

Answers

  • Godzilla
    Godzilla Contributor

    are you trying to show different lines for each year or do you just want to show one line with the percent change for each month?

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • jrubio
    jrubio Member

    Different lines for each year

  • Godzilla
    Godzilla Contributor

    You need a Year field and a Month field to do this. The Year field will be your Series, the Month will be your x axis and the field that contains the values will be the y axis. You can use beast mode to create the Year and Month fields. 

     

     

    fore the Year field  you can do something like this 

    YEAR(`Date`)

     

    and for the month 

    Month(`Date`)

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • jrubio
    jrubio Member

    I have ran into a problem with this solution.  The months on the x axis are not in calender order.

  • CantStopTheHopp
    CantStopTheHopp Contributor
    Answer ✓

    Add your `Date` field as a sort and choose ascending.

  • saipawar
    saipawar

    Did the solution work later @jrubio

  • mstorne
    mstorne

    I am having the same problem. I couldn't find solution. I want to show one line with the percent change for each year. Thank you in advance! 

Categories