Is there any way to replicate the line chart in this application in a cumulative version like this one?
I have tried this: RangeSum(Above(Sum(evo_page_like), 0, RowNo()))
But I think I had some problem with the dimensions.
Filter Pages: A, C.
Solved! Go to Solution.
I tried with the Aggr function, but the result was not correct. Take a look.
Aggr(RangeSum(Above(Sum(evo_page_like), 0, RowNo())), nome_pagina, dt_extracao_page_like)
The final values are correct (1053 and -451), but the others are not.
The right visualization would be:
All I did is to get the overall total and subtracted the cumulative value to get the downward sloping line instead of upward sloping line.
Dim, Value, Upward Sloping, DownwardSloping
1, 10, 10, 60-0 = 60
2, 20, 20, 60-10 = 50
3, 30, 30, 60-30 = 20