Cumulative percentage metric

Question & Answer
,
1

I have this dynamic table:

image
image916×352 22.1 KB
´

I have defined the metric “Nº Tarjetas usadas acumulado” like runningSum(sum({Nº Tarjetas Usadas}),[{Orden rangos días} ASC],)

And the metric “Porcentaje Tarjetas Usadas” like percentOfTotal(sum({Nº Tarjetas Usadas}))

I would like to define a new metric: “Porcentaje acumulado Tarjetas Usadas” or “cumulative percentage metric” in red. How can I define this metric of cumulative percentage?

image
image1320×398 15.3 KB

Thanks in advance

1 Like
2

Hello @edcaso, I believe if we utilize sumOver aggregations within the runningSum function, we can manage this expectation. The percent of total might be able to be utilized as well, but this is how I would calculate it:
Cumulative Percentage Metric

You can find my example calculations in the above Arena dashboard. Let me know if you have any questions!

1 Like
3

Thank you very much @DylanM.

I have managed to calculate the cumulative percentage metric with your help and advice (and your example in the Arena dashboard)

1 Like
4

Hello @edcaso, thank you for following up! I am glad that resolved the issue.