5 Replies Latest reply on Dec 20, 2016 7:27 AM by Shinichiro Murakami

    Need help to create year on year percent change chart with over 12 months on x-axis

    david.han.4

      I am hoping someone can help me learn how to create a year on year percent change line chart with over 12 months on the x-axis (e.g. 18 months).  In the attached you'll see that I'm able to create a chart with 12 months on the x-axis, however I'm unable to extend the lines into the previous year.  End game I am hoping for is for each of the region lines to show 18 months of year on year percent change.  So the x-axis would start with July 2013 (which would be percent change between July 2012 and July 2013), and end with December 2014 (which would be the percent change between December 2014 and December 2013).

       

      Context of my question is a test vs. control scenario, where my test period extends over 12 months.  You'll see that I've mocked up an example using superstore data (Tableau 9.3).