Top N Query

Groups a set of events by a dimension and aggregates them by a metric.

A Top N query allows you to list the top N values of a dimension, ordered by a metric. For example, you can list the top 10 versions of your app by number of users.

Example

{
  "aggregations": [{ "name": "count", "type": "count" }],
  "dataSource": "telemetry-signals",
  "dimension": {
    "dimension": "appVersion",
    "outputName": "appVersion",
    "type": "default"
  },
  "granularity": "all",
  "metric": {
    "ordering": "version",
    "type": "dimension"
  },
  "filter": {
    "dimension": "appID",
    "type": "selector",
    "value": "AAABBBCCC"
  },
  "queryType": "topN",
  "threshold": 10
}

Properties

All default properties and the following properties are supported:

Property	Description
dimension	A single DimensionSpec defining the dimension that you want the top taken for.
metric	A TopNMetricSpec object specifying the metric to sort by for the top list.
threshold	An integer defining the N in the topN (how many results you want in the top list).