MAX_TIME_SERIES([MAX POINTS, INTERVALS, ]TIME, VALUE)
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.VALUE
and contains the average of the values within that time frame.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.Add Calculated Field > TO_DATE
to convert 1,628,894,700,000 to 2021-08-14 01:45:00.