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

State or Status Data and Slowly Changing Dimensions

The Looker Block for State Data makes it easy to conduct deep dive analysis on how data changes over time.

User Loyalty and Other User Attributes

The Looker Block for User Loyalty segments customers and users by various attributes to highlight the factors that...

Derived Tables Pattern

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