Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm trying to get in a line chart , a moving average of 20 periods of a accumulative sums of amount .
Amount can be both positive and negative .
I have the dimension "Data" and Measure: "Quantità"
I load data for semplicity with Inline only 4 rows and i tried with a moving average of 3 periods.
I tried for accumulative : Accumulate Option and rangesum but no works
The wrong column it's "EquityLine" in the 4° row
Any idea?
Demetrio
Try this expression:
=RangeAvg(Above(RangeSum(Above(Sum({<Data=>} [Quantità]), 0, RowNo())), 0, 3))
How are you calculating 132.33? Can you elaborate?
Try this expression:
=RangeAvg(Above(RangeSum(Above(Sum({<Data=>} [Quantità]), 0, RowNo())), 0, 3))
Tyvm Sunny!!!
Now Works