Calculate percentile of specific value

[Anonymous]

Hi all,

I've a table with 2 columns - id and value. See the screenshot below and attached file.

I'd like to calculate the percentile of each of the values.

For example, value = 1 should have a percentile of 0.3 (or 30%) since out of the 10 available values, the 3 lowest values are 1.

I suppose I'm actually looking for the inverse of fractile().

Does anybody know how to do this?

Thanks,

Assaf

[swuehl]

Maybe like

=Rangesum(Above(Count(values),0,rowno())) /Count(TOTAL values)

as expression in a chart with dimension values.

Are these the numbers you are looking for?

[swuehl]

Or if you want to get the percentage for a specific selected value:

=Num(Count({<values = {"<=$(=Only(values))"}>} values) / count( {1} values),'#.00%')

[Anonymous · Accepted solution]

I ended up doing this:

=rank(Total - values,3)/count(Total values)

which gave the percentile of each value.

[naoualrh]

Hello,

I need to calculate the 80th percentile per month for a set of data. do you have an idea how I can do that in a chart expression?

Thank you,