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.

Affinity Analysis

The Looker Block for Affinity Analysis helps users understand how items or events relate to each other.

Creating Custom Cohorts

The Looker Block for Cohorting Users provides valuable insights into the lifetime purchasing patterns of your...