Series Query: Aggregation > Group

Description

The Aggregation -> Group order creates aggregate series for each of the merged series, and then performs grouping of the aggregated series.

The timestamps used for grouping combine period start times from the underlying aggregated series.

| 10-second period start   | e1.COUNT | e2.COUNT | SUM |
|--------------------------|----------|----------|-----|
| 2016-06-25T08:00:00.000Z | 2        | 1        | 3   |
| 2016-06-25T08:00:10.000Z | 2        | 1        | 3   |
| 2016-06-25T08:00:20.000Z | -        | -        | -   | Period not created because there are no detailed values in the [00:20-00:30) period for any series.
| 2016-06-25T08:00:30.000Z | 1        | 1        | 2   |
| 2016-06-25T08:00:40.000Z | 1        | 1        | 2   |
| 2016-06-25T08:00:50.000Z | 0        | 1        | 1   |

Detailed Data by Series

| entity | datetime                 | value |
|--------|--------------------------|-------|
| e-1    | 2016-06-25T08:00:00.000Z | 1     |
| e-2    | 2016-06-25T08:00:00.000Z | 11    |
| e-1    | 2016-06-25T08:00:05.000Z | 3     | e-1 only
| e-1    | 2016-06-25T08:00:10.000Z | 5     | e-1 only
| e-1    | 2016-06-25T08:00:15.000Z | 8     |
| e-2    | 2016-06-25T08:00:15.000Z | 8     |
| e-1    | 2016-06-25T08:00:30.000Z | 3     |
| e-2    | 2016-06-25T08:00:30.000Z | 13    |
| e-1    | 2016-06-25T08:00:45.000Z | 5     |
| e-2    | 2016-06-25T08:00:45.000Z | 15    |
| e-2    | 2016-06-25T08:00:59.000Z | 19    | e-2 only

Detailed Data Grouped by Timestamp

| datetime                 | e1.value | e2.value |
|--------------------------|----------|----------|
| 2016-06-25T08:00:00.000Z | 1        | 11       |
| 2016-06-25T08:00:05.000Z | 3        | -        |
| 2016-06-25T08:00:10.000Z | 5        | -        |
| 2016-06-25T08:00:15.000Z | 8        | 8        |
| 2016-06-25T08:00:30.000Z | 3        | 13       |
| 2016-06-25T08:00:45.000Z | 5        | 15       |
| 2016-06-25T08:00:59.000Z | -        | 19       |

Request

URI

POST /api/v1/series/query

Payload

[
  {
    "startDate": "2016-06-25T08:00:00Z",
    "endDate":   "2016-06-25T08:01:00Z",
    "entities": ["e-1", "e-2"],
    "metric": "m-1",
    "aggregate": {
      "type": "COUNT",
      "period": {"count": 10, "unit": "SECOND"},
      "order": 0
    },
    "group": {
      "type": "SUM",
      "order": 1
    }
  }
]

Response

Payload

[{"entity":"*","metric":"m-1","tags":{},"entities":["e-1","e-2"],"type":"HISTORY",
"aggregate":{"type":"COUNT","period":{"count":10,"unit":"SECOND","align":"CALENDAR"}},
"group":{"type":"SUM","order":1},
"data":[
    {"d":"2016-06-25T08:00:00.000Z","v":3.0},
    {"d":"2016-06-25T08:00:10.000Z","v":3.0},
    {"d":"2016-06-25T08:00:30.000Z","v":2.0},
    {"d":"2016-06-25T08:00:40.000Z","v":2.0},
    {"d":"2016-06-25T08:00:50.000Z","v":1.0}
]}]