Hi All,
I want to calculate the running of csm_time_spent_assumption for customers_. ${SuccessMetric} is a dynamic field for customer to choose either calculate the running total with the desc order by ROI or incremental revenue. So I believe, the smallest running sum with have the largest ${SuccessMetric}. But the numbers on quicksight is not working like that.
runningSum
(
sum({csm_time_spent_assumption})
,[${SuccessMetric} DESC ]
)/100
FYI: I have put a filter on this table. And the filter’s logic is base on the running total calculated. Not sure if that impact this