Running sum of average

[canmarroig]

I need to create a waterfall graph, i've 3 different products i must forecast value depending on five different variable, my expression must be a running sum of avg :

if(RowNo()=1 or RowNo()=count(Dimension)+1,0,RangeSum(Above(avg(Value),1,RowNo()-1)))

but i wonder if my approach is ok, can you help me? Here attached a simplfied model of my dashboard.

Tks!

[sunny_talwar]

Is the output not what you expect? I mean why do you have doubts?

[canmarroig]

I'm producing my dashboard from Tableau to Qv, the function RUNNING_SUM(AVG([value])) elaborates data in a different way, in QV every level up or down my value doesn't change meanwhile Tableau generate a different distribution of data.

[sunny_talwar]

Have not really used Tableau to know what the expression you gave might do... but if you can share the expected output for each bar in numerical terms, I might be able to take a look at it.

[canmarroig · Accepted solution]

Thanks, at the end formula was ok, we have to manage script for a different model capabilities, but running sum expression was ok. 🙂