0 Replies Latest reply on Mar 23, 2013 8:35 AM by Gregg Ferguson

    blending monthly and quarterly data sets

    Gregg Ferguson

      I have two data sets from separate sources - the first is monthly data and the second is quarterly data.  I would like to blend the data to generate a simple viz that looks like rows one and three below.  For example, the quarterly data established on 9/30/2012 is used for the months ending 10/31/2012, 11/30/2012 and 12/31/2012 - a new quarterly value is then established on 12/31/2012 and is used for the months ending 1/31/2013, 2/28/2013 and 3/31/2013 etc. etc.

       

      Currently the viz looks like the first two data rows below - this result is "unwanted".  What I would really like to see is the "desired" result on row three. Does anyone know how to do this?

       


      3Q20124Q20124Q20124Q20121Q20131Q20131Q2013

      9/30/1210/31/1211/30/1212/31/121/31/132/28/133/31/13
      Monthly Data98999592918789
      Current Unwanted Result - Quarterly Data1250010000115
      Desired Result - Quarterly Data
      125125125100100100

       

      Thanks

      Gregg