BigQuery Top “N” Aggregate

See the code

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

Retention Analysis

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

Gaming Analytics

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

Repeat Purchase Patterns

The Looker Block for Repeat Purchases makes it easy to identify any patterns and issues affecting your customer’s...