year over over comparison

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

Best Answer

Answers

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

  • Different lines for each year

  • 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`)

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

  • Did the solution work later @jrubio

  • 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!