directory keyboard_arrow_right analytic keyboard_arrow_right bigquery-weighted-medians

BigQuery Weighted Medians

See the code

Weighted medians are a helpful statistical tool to measure the central tendency of a multi-part data set. If the weight of each component of the data set is equal, then the median is the same as the weighted median.

This function is created using BigQuery’s UDF capabilities.

See the code

Related Blocks

Derived Tables Pattern

The Looker Block for a Derived Table Pattern allows user to create temporary tables to optimize table structure for...

Retention Analysis

The Looker Block for Retention Analysis makes it simple to understand the factors that influence and motivate strong...

State or Status Data

The Looker Block for State Data makes it easy to conduct deep dive analysis on how data changes over time.