Hi @Jesse,
For my KPI Dashboard, I want to create a trend of week over week Savings%
Where Savings% = Savings/Spend
But trend would tell what was my savings% 2 weeks ago, what was my savings% up to last week and what is my savings% upto this week
How can I calculate the cumulative savings% week over week in Quicksight using the data Spend, Savings, Date, and Savings% data ?
Here is the excel version example that I want to do in quick sight
How are you getting the last value?
It’s not a cumulative sum?
I was first thinking of runningSum.
Do you want a runningAvg?