6 Replies Latest reply: Jul 9, 2012 10:52 AM by dave4291 RSS

    Multiple lines in a line graph

      Hi,

       

      I have created one line graph by week for the amount of Cigarette Sales. I have a requirement to plot the graph in such a way so that it plots for the weeks of the current year and also plots another line for the same weeks of previous year. So, that we can have a current year vs last year comparison. My dimension is weeknumber and my expression uses avg(cigarette_sales). My Current year is 2012 and my previous year is 2011. Week is a field defined according to my calender.

       

      Any ideas how to accomplish this? I would necessarily need 2 Line graphs to be displayed for 2 years in a single Line chart.

       

      All help would be highly appreciated.

       

      Thanks,

      Tutan