I have a user requirement. He wants to see 12 months trends of particular KPI's in line graph. I have months from Jan to Dec as filter selections. His requirement is when November 2015 is selected, Graph should be plotted from November 2014 to November 2015 i.e trend should be seen from Nov to Nov. When Dec 2015 is selected, line graph should show trend from Dec 2014 to Dec 2015. Likewise when July 2015 is selected, July 2014 to July 2015 to be shown.
thanks for the solution i have done this. i know this thread is old but
But i have a hitch: what if i wanted to display all the Months on the x axis. regardless of if i have data in the months or not.
for example: if March 2017 data = 0, and December 2017 is selected, i still want my chart x axis to read from: Dec2016, Jan2017, Feb2017, March2017,Apr2017, May2017 ,June2017 ,July2017 ,Aug2017, Sept2017, Oct2017, Nov2017 ,Dec2017