Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Summarize Percentile Not Working

The_Fray
8 - Asteroid

Hello,

 

I am having issues with the Summarize tool and percentiles. 

 

I want the percentiles for a column that looks like the following:

 

The_Fray_0-1635974847574.png

The_Fray_2-1635975042485.png

 

 

but once I run it through the summarize percentile nothing happens:

 

The_Fray_1-1635974895050.png

 

i was expecting 0 - 100 percentile, not numbers over 200 with no changes to the acutal data.

 

Thanks,

 

Fray

4 REPLIES 4
Maskell_Rascal
13 - Pulsar

Hi @The_Fray - your issue is with the group by in the summarize tool. When you group by, the summarize tool applies any calculation to the those groupings. 

The_Fray
8 - Asteroid

Hmm. I see what you are saying now. Is there a way though to get the percentile for every row in the data? for example, if the first 5 numbers in the dataset at 25, 50, 66, 75, 100, I want to know the percentile for each one of those numbers.

 

Thanks

Pingu
10 - Fireball

I am not sure if its possible without using sum, otherwise you will always get 1 value.

 

Pingu_0-1636014749874.png

 

Does this what you need?

Maskell_Rascal
13 - Pulsar

@The_Fray - can you provide an input and expected output? 

Labels