MEDIANStay organized with collectionsSave 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
Xcannot be an aggregated field or the result of an aggregation function.
MEDIANreturns the center value ifXcontains an odd number of values. IfXcontains an even number of values,MEDIANwill 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,MEDIANis implemented using the BigQueryAPPROX_QUANTILESfunction. ApplyingMEDIANto data coming from BigQuery may return slightly different results than applyingMEDIANto 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."],[],[]]
