PERCENTILE

Returns the Nth percentile of all values of X.  N is a floating point value between 0 and 100 (exclusive).

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

• Calculated fields
• Looker Studio function list