BigQuery Top “N” Aggregate
See the Code
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
-
Use-Cases
Sales Marketing Product Customer Success Customer Support Operations & Logistics Finance
-
Industry
Any
Related Blocks
Derived Tables Pattern
The Looker Block for a Derived Table Pattern allows user to create temporary tables to optimize table structure for...
Measuring Activity and Engagement
The Looker Block for Measuring Activity and Engagement helps organization understand how to engage their user base.
Peer Comparison: Comparison Against Rest of Population
The Looker Block for Peer Comparison makes it simple to compare a dynamic group to the rest of users.
