Percentile

[johnreda]

I'm using the Summarize Percentile feature and instead of out putting actual numbers from my data set it's giving me decimals that aren't in my dataset. Is there any way to change or fix this?

There are no decimals in my data set, but as you can see, the output has them.

[PhilipMannering]

This might be accurate. For example the 50th percentile is half way through your data. So the 50th percentile of [1, 2, 3, 4] is half way between 2 and 3 → 2.5, even though 2.5 isn't in the data.

[Qiu]

@johnreda 
I think you are finding something maybe. hehe.
I test the  10% percentile for {1,2,3,4,5,6,7,8,9}, whch alteryx gives 1.8, while it should be 1.
lets report this in.

[Qiu]

@PhilipMannering 
Thank you for the comment. 
but according to the help, it should return the row value rather than doing any calculation.

[johnreda]

Thank you! I read that section of the help as well and then the output didn't align so thats why I asked my question. What do we do from here?