BigQuery Top “N” Aggregate

See the Code

directory  -  analytic

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

This function is helpful anytime a user wants to identify the top or bottom data points from a data set or calculation. Common examples include:

  • Top selling items
  • Top performing regions or customer segments
  • Poorest performing sales reps
  • Most frequent time-of-day for orders
  • Top performing products and/or services
See the Code

Related Blocks

BigQuery Weighted Medians

Weighted medians are a helpful tool when analyzing data entries that are repeated across multiple sets.

AB Testing with Statistical Significance

The Looker Block for AB testing lets you compare how a group acts under two sets of conditions.

Measuring Activity and Engagement

The Looker Block for Measuring Activity and Engagement helps organization understand how to engage their user base.