How can I make a cumulative frequency of a field?

Question & Answer
, ,
1

image
image829Ă—639 137 KB

2

Hello,

Wouldn’t a runningSum do the trick for you?
runningsum(
sum(Frequency),
[{Late Arrival Reason} ASC]
)

You would have to sort your visual by “Late Arrival Reason”.

Note that, in your exemple, I wouldn’t expect the Cumulative Frequency you provide but 25, 42,59, 69,…

3

Thank you for your feedback, I attach another image, I hope to explain myself better.

I want to make a cumulative frequency of “arrival_status”. It can be possible?

image
image1021Ă—431 31.6 KB

4

Hello,

Create a calculated field with the following formula:
runningSum(
count(arrival_status),
[arrival_status ASC]
)

and add it to your visual as the value.
Sort your group-by “arrival_status” attribute by arrival_status A-Z.

1 Like
5

Thank you very much for the support, it helped me a lot

6

Very glad. My pleasure.