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: