Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to get percentile values all at once in alteryx?

preetham_tsp
5 - Atom

I need the values of a column displayed for custom percentile points. ex: 1st percentile, 25th percentile, 50th, 75th,90th, 99th, 100th

much like how dataframe.quantiles([0.01,0.25,0.5,0.99]) displays in python. How do I do this?

 

I tried summarize function but I believe you get value for only 1 percentile point at a time and not all at once

2 REPLIES 2
MatthewO
Alteryx Alumni (Retired)

@preetham_tsp you are able to calculate percentiles using the Summarize tool. In the attached example, I have configured it to retrieve the 25, 50, 75, and 100 percentiles. I hope this is helpful for you!

 

image.png

achourou
5 - Atom

Thanks a lot

Labels
Top Solution Authors