Stay organized with collections
Save and categorize content based on your preferences.
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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-07-22 UTC."],[],[],null,["# MEDIAN\n\nReturns the median value from a set of numbers.\n\nSample usage\n------------\n\n`MEDIAN(Page Views)`\n\nSyntax\n------\n\n`MEDIAN( `\u003cvar translate=\"no\"\u003eX\u003c/var\u003e` )`\n\n### Parameters\n\n- \u003cvar translate=\"no\"\u003eX\u003c/var\u003e - a numeric field or expression.\n\nNotes\n\n- \u003cvar translate=\"no\"\u003eX\u003c/var\u003e cannot be an aggregated field or the result of an aggregation function.\n- `MEDIAN` returns the center value if \u003cvar translate=\"no\"\u003eX\u003c/var\u003e contains an odd number of values. If \u003cvar translate=\"no\"\u003eX\u003c/var\u003e contains an even number of values, `MEDIAN` will interpolate between the two center values.\n\nExamples\n--------\n\nNotes\n-----\n\nFor BigQuery data sources, `MEDIAN` is implemented using the BigQuery [APPROX_QUANTILES](/bigquery/docs/reference/standard-sql/approximate_aggregate_functions#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.\n\nRelated resources\n-----------------\n\n- [Calculated fields](/looker/docs/studio/about-calculated-fields)\n- [Looker Studio function list](/looker/docs/studio/function-list)"]]
