6 Replies Latest reply: Feb 29, 2012 9:34 AM by Martin Edwards RSS

    Compare data from two dates

      Hi,

       

      I wish to compare forecasts from two different forecast versions,

       

      I have a table which basically is design as such:

       

      ForecastDateSalesDateForecast
      2012-01-012012-03-01100
      2012-01-012012-04-0180
      2012-01-012012-05-0190
      2012-02-012012-03-01100
      2012-02-012012-04-01100
      2012-02-012012-05-01100

       

       

      I have created a variable called MaxForecastDate defined as Max(ForecastDate). In this case, it returns '2012-02-01', and is used to determine the latest forecast version.

       

      I have then created a chart with dimension SalesDate and expression:

       

      =SUM({<GSFDate={'2012-02-01'} >} Forecast)
      

       

      This works as expected, but I would like that the chart is dynamically updated when a new ForecastDate is added. To compare forecasts from the two forecast dates, I am planning to use the function AddMonth(MaxForecastDate, -1) .

       

      Any help would be very appreciated!

      Best regards

      Martin