Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I try to realize a graph with 3 curves:
- Accumulated curve (data A)
- Accumulated curve (data B)
- Curve representing the division of the accumulation of the data A by the accumulation of the data B
I manage well to make 2 first ones (with option "total accumulation" checked in the properties of the graph) but not the 3rd...
I think it exists a formula for that, but my tests are not really decisive for the moment...
Thank you in advance for any help on this subject!
Vincent
Skip the option "Accumulation" and do it in the formula instead.
First, add expressions for the accumulated A and B:
RangeSum(A, above(A_accumulated))
RangeSum(B, above(B_accumulated))
Label these expressions "A_accumulated" and "B_accumulated".
I assume there is only one value per bin. If there are several values per bin, you need to use Sum(A) instead of A as first parameter in RangeSum.
Finally, add an expression A_accumlated/B_accumlated.
Skip the option "Accumulation" and do it in the formula instead.
First, add expressions for the accumulated A and B:
RangeSum(A, above(A_accumulated))
RangeSum(B, above(B_accumulated))
Label these expressions "A_accumulated" and "B_accumulated".
I assume there is only one value per bin. If there are several values per bin, you need to use Sum(A) instead of A as first parameter in RangeSum.
Finally, add an expression A_accumlated/B_accumlated.
Try to calculate the accumulated curves (instead of the chart properties option) like
=rangesum(above([data A],0, rowno() ))
=rangesum(above([data B],0, rowno() ))
[for the first parameter to above, use your current expressions]
Then you could just use
=column(1) / column(2)
as division of both accumulated values.
Hope this helps,
Stefan
thanks for your answers, both are ok !