
1. Re: Multiple cumulative distribution functions in one plot
Jim Dehner Mar 27, 2018 5:02 AM (in response to Rui Sun)Good morning
not certain I fully understand the goal  your statement identifies the need for 3 plots  1 for each carrier but one carrier has only a single data point which is insufficient for your running calcualtions
that said see the attached and below
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

Forum_v10.2.twbx 20.2 KB


2. Re: Multiple cumulative distribution functions in one plot
Rui Sun Mar 27, 2018 7:31 AM (in response to Jim Dehner)Hi Jim,
Thanks for your reply.
I only uploaded a sample and my real data has around 1M points for each carrier, so it would suffice for the plot.
However the end of each curve (for the sake of discussion let's suppose that single point has been expanded to a curve) should reach 100% level, meaning that 100% of values for that carrier is less than or equal to x. This can be observed from my original workbook. Could you please revise the solution to reflect this property?
In other words, a point (x, y) on a curve means y percent of the data is less than or equal to x; thus, each curve should approximately cover the range (0, 100).
Kind Regards,
Ryan

3. Re: Multiple cumulative distribution functions in one plot
Jim Dehner Mar 27, 2018 7:40 AM (in response to Rui Sun)2 of 2 people found this helpfulgot it
see the attached
I modified the formula to this
and it returns this
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

4. Re: Multiple cumulative distribution functions in one plot
Rui Sun Apr 9, 2018 2:29 AM (in response to Jim Dehner)1 of 1 people found this helpfulHi Jim,
Actually I think the formula should be `RUNNING_SUM(COUNT([DELIVERY_TIME])) / WINDOW_SUM(COUNT([DELIVERY_TIME]))`.
Thanks,
Ryan