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](https://docs.cloud.google.com/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.

## Related resources

- [Calculated fields](https://docs.cloud.google.com/data-studio/about-calculated-fields)
- [Data Studio function list](https://docs.cloud.google.com/data-studio/function-list)