-
Streams
- Compute
- Overview
- Group By Ranges & Buckets
- Data Explorer Guide
- Video Completion Funnel
- Saved Queries
- Compute Pricing Guide
- Custom Ad Performance
- Session Timing Metrics
- Cohort Analysis
- Retention Analysis
- Funnel Analysis
- Creating a Funnel with an OR Condition
- Stripe Revenue Queries
- Create a Email Nightly Report
- Query Tuning
- Cached Queries
- Cached Datasets
- Paid Session Metrics
- User Engagement
- Visualize
Top Results of a Table
Say you want to…
- determine which of your customers spend the most
- rank your blog posts based on number of pageviews
- figure out which customers are making the most API requests
You can use the Keen Group By and Order By syntax to:
- Calculate results that are grouped by one or more properties (like customerId or postId)
- Return those results in ascending or descending order, ordering by the results or by group names
- Optionally limit the results to a subset (like the Top 10)
In this example, we want to find the top ten most active users in our game between December 1, 2013 and December 1, 2014:
