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
Alteryx

@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