0 Replies Latest reply: Sep 21, 2016 8:08 AM by Corinna Theiß RSS

    visualize changes in data based on previous date

    Corinna Theiß

      Hi All,

       

      I need to visualize (table) two keyfigures and their change over time, based on one Dimension.

      This is These Points were you see a Change in a line Chart for example.

       

      I tried to solve it with previous() and peek() in the script, with before(), above() to query the values from the date loaded before... but could not manage to get it running. Data should always be compared to the previous date loaded.

      data is available always for today and today-1 (to -4) weeks.

       

      Data example:  

      Dimension1 Date Value1 Value2
      A27.08.20163020
      A03.09.20163020
      A10.09.20164010
      A17.09.20164020
      B27.08.20161010
      B10.09.20162030
      B17.09.20162030

       

      The result should show e.g. that keyfigure "Value1" for Dimension "A" changed from 30 on 03.09. to 40 on 10.09.

       

      possible Result: 

       

       

         

      Dimension1KeyfigureChangeFromDateChangeFromChangeToDateChangeTo
      AValue103.09.20163010.09.201620
      AValue203.09.20164010.09.201610
      AValue210.09.20161017.09.201620
      BValue127.08.20161010.09.201620
      BValue227.08.20161010.09.201630

       

       

      any help appreciated!