Looker

Marketplace

Develop for Marketplace

Blocks

BigQuery Medians

By Looker
Medians are a helpful statistical tool to measure the central tendency of a multi-part data set.
Medians are a helpful statistical tool to measure the central tendency of a multi-part data set.

Overview

This is not an officially supported Google product.

Median aggregations should be used to determine central tendency whenever a dataset contains outliers that would otherwise throw off the “average” of the data set. For example, medians are often used to determine the average age and average income of a given population.

This function is created using BigQuery’s UDF capabilities.

Category

Blocks

Related Content

Amazon Redshift Administration

GoogleFine-tune your Redshift deployment with a comprehensive view of performance and query analysis.Blocks

BigQuery Information Schema Performance Monitoring

GoogleMonitor and Explore your BigQuery Usage and PerformanceBlocks

© 2025 Looker Data Sciences, Inc.
Privacy | Terms | Cookies