Notification

This Help Center is moving to Cloud. Learn more about the migration.

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

Was this helpful?

How can we improve it?
true
What's new in Looker Studio?

Learn about new features and recent changes. Looker Studio release notes live on Google Cloud.

Search
Clear search
Close search
Google apps
Main menu