MAX_TIME_SERIES

Get the maximum value per time interval. This aggregation is useful for collecting time-series data for graphs. The size of the time intervals is configurable & dynamic; the time interval used will change depending on how many points you wish to hold per aggregation key ‌You can change the time interval and/or the number of points per interval to suit your graph.
Syntax
MAX_TIME_SERIES([MAX POINTS, INTERVALS, ]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.
Returns
An array of key value pairs, the key is the time (in epoch ms) and the value is of type VALUE and contains the average of the values within that time frame.
Note: 
Series are arrays, so MAX_TIME_SERIES will only appear in the Add Aggregate dialog when the source file is hierarchical. When uploading files, Upsolver's Infer Types checkbox is used to recognize epoch time as a time field. But it only recognizes epoch time in milliseconds.
When uploading files with INFER TYPES - only 13 digit fields are recognized as valid dates 1628894700 is converted to "data.time" 1,628,894,700.  
Use Add Calculated Field > TO_DATE to convert 1,628,894,700,000 to 2021-08-14 01:45:00.
AVAILABLE IN
Output Type                    Availablity 
Aggregated Outputs     NO 
Explicit Lookup Table   YES 
Inline Joins\Lookups    NO
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
Collect from server metric events - max cpu over time - in order to display on a graph in a web page:
1
SELECT 
2
   data.serverIp AS serverip:STRING,
3
   MAX_TIME_SERIES(2, [60000, 300000], data.time, data.cpuUsage) AS max_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
   "max_cpu":[
4
      {
5
         "value":9.6,
6
         "key":1628894700000
7
      }
8
   ]
9
}{
10
   "serverip":"10.0.0.1",
11
   "max_cpu":[
12
      {
13
         "value":99.6,
14
         "key":1628894700000
15
      },
16
      {
17
         "value":55,
18
         "key":1628895000000
19
      }
20
   ]
21
}
Copied!
Related Functions
​MAX
MAX_BY
MAX_EACH​
Dialog

MAX_EACH

MIN

Last modified 8mo ago

Copy link

Contents