Looker Studio is now called Data Studio. Learn more about this change.

MEDIAN

Returns the median value from a set of numbers.

Sample usage

MEDIAN(Page Views)

Syntax

MEDIAN( X )

Parameters

  • X - a numeric field or expression.

Notes

  • X cannot be an aggregated field or the result of an aggregation function.
  • MEDIAN returns the center value if X contains an odd number of values. If X contains an even number of values, MEDIAN will interpolate between the two center values.

Examples

Example formula Input Output
MEDIAN(Page Views)
  • 95
  • 100
  • 92
 95
MEDIAN(Page Views)
  • 100
  • 95
 97.5

Notes

For BigQuery data sources, MEDIAN is implemented using the BigQuery APPROX_QUANTILES function. Applying MEDIAN to data coming from BigQuery may return slightly different results than applying MEDIAN to the same data coming from other data source types.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2026年08月26日 UTC.