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?



      Monthly Data98999592918789
      Current Unwanted Result - Quarterly Data1250010000115
      Desired Result - Quarterly Data