BigQuery Top “N” Aggregate

See the Code

directory  -  analytic  -  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.

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

Derived Tables Pattern

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

BigQuery Medians

Medians are a helpful statistical tool to measure the central tendency of a multi-part data set.

Sequencing Transactions

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