2 Replies Latest reply: May 22, 2012 11:05 AM by Laurie Bayles RSS

    Year-over-Year Trending Graph

    aclawson

      Does anyone know how to graph a comparative y/y? I want the graph to look like this:

      error loading image

       

      The QV data is in a two-dimension table like this:

       



       

      MonthSales Volume
      1/31/2007663.25
      2/28/2007672.15
      3/31/2007765.51
      4/30/2007776.44
      5/31/2007830.62
      6/30/2007748.55
      7/31/2007835.88
      8/31/2007843.76
      9/30/2007878.79
      10/31/2007847.39
      11/30/2007851.20
      12/31/2007786.00
      1/31/2008696.64
      2/29/2008764.72
      3/31/2008878.70
      4/30/2008875.89
      5/31/2008807.88
      6/30/2008773.22
      7/31/2008917.78
      8/31/20081,109.32
      9/30/2008823.75
      10/31/2008839.87
      11/30/2008734.93
      12/31/2008864.93
      1/31/2009838.23
      2/28/2009646.93
      3/31/2009804.08
      4/30/2009750.71
      5/31/2009776.80
      6/30/2009723.55
      7/31/2009909.66
      8/31/2009859.06
      9/30/2009884.46
      10/31/2009810.95
      11/30/2009774.06
      12/31/20091,028.34
      1/31/2010782.46
      2/28/2010850.34
      3/31/20101,074.08
      4/30/2010891.20


       

      I realize I could create a cross-table looking like this:

       

       

      YearJanFebMarAprMayJunJlyAugSepOct
      2007663.25672.15765.51776.44830.62748.55835.88843.76878.79847.39
      2008696.64764.72878.7875.89807.88773.22917.781,109.32823.75839.87
      2009838.23646.93804.08750.71776.8723.55909.66859.06884.46810.95
      2010782.46850.341,074.08891.2


       

      But given the volume of detail I'm dealing with (Jan '08 to present resulting in 200,000ish records), it's just impractical.

       

      Any suggestions?