SUM_TIME_SERIES

Returns the sum of all values per time interval. This aggregation is useful for collecting time-series data for graphs.

The size of the time intervals is configurable and dynamic; the time interval used changes depending on how many points you wish to hold per aggregation key.

The time interval and/or the number of points per interval can be changed to suit your needs.

Syntax

SUM_TIME_SERIES([MAX_POINTS, INTERVALS,] TIME, VALUE)

Arguments

MAX_POINTS

Type: integer

Default: 300

(Optional) The maximum amount of points to hold before reducing the resolution to the next interval size.

INTERVALS

Type: array

Default: [60000, 300000, 600000, 1800000, 3600000, 10800000, 21600000, 43200000, 86400000]

(Optional) Array of integers representing the time interval buckets in epoch ms for which to return data.

If the aggregation has more than MAX_POINTS values in the given window, it will use the next interval from this array to reduce the number of points to comply with MAX_POINTS.

TIME

Type: numeric

The field with the time in epoch ms that VALUE is associated with.

VALUE

Type: any type

The field to sum up per TIME bucket.

Returns

Type: array

Returns an array of key value pairs where the key is the time (in epoch ms) and the value is the sum of all values VALUE from within that time frame.