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

    Percentage growth in chart

    Max Ålander



      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(%)


      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.