topic Re: Line Graph: Accumulating a Fraction Measure in App Development

Line Graph: Accumulating a Fraction Measure

cmc — Wed, 08 Nov 2023 15:41:42 GMT

I have a line graph with a measure that is a fraction e.g. sum(A) / sum(B).

I would like to accumulate the values of A & B separately. I don't want the total measure values to simply be summed up for each step of the line graph.

Currently, my expression looks like this:

=
RangeSum(Above(
Sum(A)
,0,RowNo()))

RangeSum(Above(
Sum(B)
,0,RowNo()))

This works when there is no dimension breakdown in the line graph (e.g. there is only 1 line), but when I add a line dimension, the calculations are incorrect for the accumulated measure.

Re: Line Graph: Accumulating a Fraction Measure

vincent_ardiet_ — Wed, 08 Nov 2023 16:20:52 GMT

Indeed, this doesn't seem to work as expected whereas in a table or a pivot this is working well...

Re: Line Graph: Accumulating a Fraction Measure

cmc — Wed, 08 Nov 2023 22:19:47 GMT

Agreed, it is very unfortunate 🙁