Aggregate name |
Description |
INTERPOLATIVE |
1. order interpolated values. |
INTERPOLATIVE ZERO-ORDER |
0. order interpolated values. |
TOTAL |
The totalized value (time integral) of the data over the resample interval. |
AVERAGE |
The average data over the resample interval. |
TIMEAVERAGE |
The time weighted average data over the resample interval. |
COUNT |
The number of raw values over the resample interval. |
STDEV |
The standard deviation over the resample interval. |
MINIMUMACTUALTIME |
The minimum value in the resample interval and the timestamp of the minimum value. |
MINIMUM |
The minimum value in the resample interval. |
MAXIMUMACTUALTIME |
The maximum value in the resample interval and the timestamp of the maximum value. |
MAXIMUM |
The maximum value in the resample interval. |
START |
The value at the beginning of the resample interval. The time stamp is the time stamp of the beginning of the interval. |
END |
The value at the end of the resample interval. The time stamp is the time stamp of the end of the interval. |
DELTA |
The difference between the first and last value in the resample interval. |
REGSLOPE |
The slope of the regression line over the resample interval. |
REGCONST |
The intercept of the regression line over the resample interval. This is the value of the regression line at the start of the interval. |
REGDEV |
The standard deviation of the regression line over the resample interval. |
VARIANCE |
The variance over the sample interval. |
RANGE |
The difference between the minimum and maximum value over the sample interval. |
DURATIONGOOD |
The duration (in seconds) of time in the interval during which the data is good. |
DURATIONBAD |
The duration (in seconds) of time in the interval during which the data is bad. |
PERCENTGOOD |
The percent of data (1 equals 100 percent) in the interval, which has good quality. |
PERCENTBAD |
The percent of data (1 equals 100 percent) in the interval, which has bad quality. |
WORSTQUALITY |
The worst quality of data in the interval. |
ANNOTATIONS |
The number of annotations in the interval. |
DISPLAYVALUES |
Values that give the best trend curve representation for a specific number of pixels. The desired start/end time and the number of x-pixels (nx) available, are used to divide the period into nx resample intervals (1 resample interval per x-pixel). For each resample interval, anything from 0 to 4 data points may be returned. At most, the following data points are returned for each resample interval: the first data point, the maximum data point, the minimum data point and the last data point. |
LOWPASSFILTER |
Lowpass filtering of the RAW data for the given period. The number of datapoints returned is the same as the number of raw datapoints.The resample interval is interpreted as the time-constant (T). The algorithm is:v(n+1) = v(n) + dT*(v(n+1) - v(n))/T ,wherev - valuen - datapoint indexdT = timestamp(n+1) - timestamp(n)If T <= dT, no filtering is applied to avoid instability. |
MOVING AVERAGE DISCRETE |
Moving average of the RAW data for the given period, ignoring the time between datapoints. The number of datapoints returned is the same as the number of raw datapoints.The resample interval is interpreted as the number of values in the window. For the first window, a cumulative average is applied. |
MOVING AVERAGE TIME |
Moving average of the RAW data for the given period, taking the time between datapoints into account. The number of datapoints returned is the same as the number of raw datapoints.The resample interval is interpreted as the the window size. For the first window, a cumulative average is applied. |
RAW |
RAW is not an aggregate, but is often listed with the aggregates. Most aggregations are calculated from RAW data. RAW means all the data in a period. |