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.
Change 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.