2 Replies Latest reply on Dec 19, 2016 2:48 PM by Alban Spella-Barberet

    How to calculate an accumulated variation?

    Alban Spella-Barberet

      Hello,

       

      I have a simple dataset:

       

      two cities and a count during several weeks. I also have variations from a week to another week.

      I am trying to display in a way I can trend an accumulated variation per week.

       

      A would show:

      0,0,0,1,3,3,3,167,204

      B would whow:

      0,236,236,237,237,237,271,262.

       

      One idea is to display the count minus the count of the oldest week on a calculated field however I am not sure how to do this, basically:

       

      New count= Count - count of week 21/10/2016 (or oldest week).

       

         

      CityCountVARIATIONENDING_WEEK
      A1057221/10/2016
      A1057028/10/2016
      A105704/11/2016
      A1058111/11/2016
      A1060218/11/2016
      A1060025/11/2016
      A94202/12/2016
      A11071659/12/2016
      A11433616/12/2016
      B511021/10/2016
      B74723628/10/2016
      B74704/11/2016
      B748111/11/2016
      B748018/11/2016
      B748025/11/2016
      B782349/12/2016
      B773-916/12/2016