PERCENTILE

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

  • X cannot be an aggregated field or the result of an aggregation function.
  • N can 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

Related resources

Was this helpful?
How can we improve it?