SUM_TIME_SERIES

The sum of the values per time interval.
Syntax
SUM_TIME_SERIES ([MAX POINTS, INTERVAL, ]TIME, VALUE)]
Arguments
MAX POINTS:   The maximum amount of points to hold before reducing the resolution to the next
                               interval size. Default Value: 300 
INTERVALS:       An array of integers representing the time interval buckets to return data for. 
                              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 amount of points to comply 
                              with MAX POINTS .  Default: [60000, 300000, 600000, 1800000, 3600000, 
                              10800000, 21600000, 43200000, 86400000]
TIME:                An expression returning the time value that the VALUE is to be associated with. 
VALUE:               An expression returning the value to aggregate in the provided TIME bucket.
Notes
The time series is calculated from the start of Unix Time.
Returns
The sum of the values per time interval.
The interval are based on Unix Time that starts at a point before the first data entry time.
Example
Data
1
[
2
   {
3
      "serverIp":"10.0.0.1",
4
      "time":1628894700000,
5
      "cpuUsage":52.3
6
   },
7
   {
8
      "serverIp":"10.0.0.1",
9
      "time":1628894760000,
10
      "cpuUsage":2.4
11
   },
12
   {
13
      "serverIp":"10.0.0.1",
14
      "time":1628894820000,
15
      "cpuUsage":99.3
16
   },
17
   {
18
      "serverIp":"10.0.0.1",
19
      "time":1628894880000,
20
      "cpuUsage":99.6
21
   },
22
   {
23
      "serverIp":"10.0.0.1",
24
      "time":1628894940000,
25
      "cpuUsage":12.3
26
   },
27
   {
28
      "serverIp":"10.0.0.1",
29
      "time":1628895000000,
30
      "cpuUsage":55
31
   },
32
   {
33
      "serverIp":"10.0.0.2",
34
      "time":1628894700000,
35
      "cpuUsage":2.3
36
   },
37
   {
38
      "serverIp":"10.0.0.2",
39
      "time":1628894760000
40
   },
41
   {
42
      "serverIp":"10.0.0.2",
43
      "time":1628894820000,
44
      "cpuUsage":9.3
45
   },
46
   {
47
      "serverIp":"10.0.0.2",
48
      "time":1628894880000,
49
      "cpuUsage":9.6
50
   },
51
   {
52
      "serverIp":"10.0.0.2",
53
      "time":1628894940000,
54
      "cpuUsage":2.3
55
   }
56
]
Copied!
Query
How much cpu is used for each time period:
1
SELECT 
2
   data.serverIp AS serverip:STRING,
3
   SUM_TIME_SERIES(2, [60000, 300000], data.time, data.cpuUsage) AS sum_cpu
4
FROM 
5
   TIME_SERIES_DATA_w_NULL
6
GROUP BY 
7
   data.serverIp      
Copied!
Results
1
{
2
   "serverip":"10.0.0.2",
3
   "sum_cpu":[
4
      {
5
         "value":23.500000000000004,
6
         "key":1628894700000
7
      }
8
   ]
9
}{
10
   "serverip":"10.0.0.1",
11
   "sum_cpu":[
12
      {
13
         "value":265.9,
14
         "key":1628894700000
15
      },
16
      {
17
         "value":55,
18
         "key":1628895000000
19
      }
20
   ]
21
}
Copied!
Related Functions
​SUM
LAST_TIME_SERIES
MAX_TIME_SERIES
MIN_TIME_SERIES​
Dialog

SUM_EACH

WEIGHTED_AVERAGE

Last modified 8mo ago

Copy link

Contents