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.

Related resources

• Calculated fields
• Looker Studio function list