BigQuery Weighted Medians

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.

Use-Cases

Sales Marketing Product Customer Success Operations & Logistics
Industry

Any

See the code

Related Blocks

Gaming Analytics

Build better games by examining the entire lifecycle of your players from acquisition, to monetization and retention.

BigQuery Top “N” Aggregate

Top “N” allows users to isolate the top or bottom data points, based on a selected criteria, in a given data set.

Derived Tables Pattern

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