PERCENTILE

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

• X cannot be an aggregated field or the result of an aggregation function.
• N can be a decimal value.

Example

Example formula	Input	Output
PERCENTILE(Users per day, 50)	95 100 92	95
PERCENTILE(Users per day, 30.5)	95 100 92	93.83

Related resources

• Calculated fields
• Looker Studio function list