Returns the value at a given percentile of a numerical data set.
Sample usage
PERCENTILE(Users per day, 50)
Syntax
PERCENTILE(X, N)
Parameters
X- a numeric field or expression.N- a number in the range 1 through 99.
Notes
Xcannot be an aggregated field or the result of an aggregation function.Ncan be a decimal value.
Example
| Formula | Input | Output |
PERCENTILE(Users per day, 50) |
Users per day : 95 Users per day : 100 Users per day : 92 |
95 |
PERCENTILE(Users per day, 30.5) |
Users per day : 95 Users per day : 100 Users per day : 92 |
93.83 |