Upsolver
Search…
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!

Dialog