Hi all,
I've search the community and see most posts for calculating are using Macro, however, I have trouble downloading it. I was wondering if I could formula tool to get the 99.97% percentiles or any custom number of percentiles. I also don't understand how the percentiles works in the summarized tool, it doesn't see to allow any input, and the output make sense for me.
I am dealing with 1.5Mil row of data. In excel, I could use Percentile.ext function, but i couldn't figure out how to use this in Alteryx.
thank you for your help in advance!
Example: With the following data, I got $99754 is the 99.97% percentile by using the excel formula.
Data |
-200.00 |
2.00 |
30.00 |
99997.00 |
10000.00 |
0.00 |
7.00 |
100.00 |
20.00 |
10.00 |
Solved! Go to Solution.
Is this what you're after? Returns the same result as your excel function did. The input is down in the text box in the bottom left.
Thank you so much! This is exactly what I am looking for!