topic Re: Accumulate measure in a Line Chart in App Development

Accumulate measure in a Line Chart

Wed, 09 Aug 2017 19:04:06 GMT

Hi, Everyone.

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.

Thanks.

dan_sullivan — Wed, 09 Aug 2017 21:07:46 GMT

Maybe reference this prior post for help?

Fri, 11 Aug 2017 15:47:38 GMT

Hi, Dan.

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:

Regards.

sunny_talwar — Fri, 11 Aug 2017 16:54:10 GMT

Try this

Aggr(Sum(TOTAL <nome_pagina> evo_page_like) - RangeSum(Above(Sum(evo_page_like), 1, RowNo())), nome_pagina, dt_extracao_page_like)

Fri, 11 Aug 2017 18:38:15 GMT

Hi, Sunny.

It worked.

I think understood the logic behind your expression. But can you explain it to us?

Thanks.

sunny_talwar — Fri, 11 Aug 2017 18:42:21 GMT

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.

For example

Dim, Value, Upward Sloping, DownwardSloping

1, 10, 10, 60-0 = 60

2, 20, 20, 60-10 = 50

3, 30, 30, 60-30 = 20