6 Replies Latest reply: Sep 28, 2017 9:30 AM by Sunny Talwar RSS

    Percentage growth in chart

    Max Ålander

      Hi,

       

      In my chart visualisation I'm trying to set up a table where I can see the percentage change/growth of a value over time.

       

      I have a table with Week in the first column and Value in the second column. To that I want to add a third column with a calculation of growth/change from week to week. Note that we cannot calculate the change for the first row since there is no previous week to compare to.

       

      WeekValueChange since last week(%)
      10200-
      11400100%
      12300-25%
      1345050%

       

      How would this be calculated?

       

      The solution doesn't have to be for weeks specifically but could just as well handle dates, months or years.

       

      Thank you for your time.