Calling all Racers for the Alteryx Grand Prix! It's time to rev your engines and race to the stage at Inspire! Sign up here.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer 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

1 REPLY 1
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

Labels