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

Sequencing Transactions

The Looker Block for Sequencing Transactions makes it easy to identify trends among returning customers.

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.

Daily, Weekly, Monthly Active Users

The Looker Block for Active Users provides three metrics to gauge user engagement.