Returns the Nth percentile of all values of X. N is a floating point value between 0 and 100.
Sample usage
PERCENTILE(Users per day, 50)
Syntax
PERCENTILE(X, N)
Parameters
X- a numeric field or expression.N- a number in the range 0 to 100.
Notes
Xcannot be an aggregated field or the result of an aggregation function.Ncan be a decimal value.
Example
| Example formula | Input | Output |
|---|---|---|
PERCENTILE(Users per day, 50) |
|
95 |
PERCENTILE(Users per day, 30.5) |
|
93.83 |