Aggregation types

In different elements of the Optimo IoT system it is possible to calculate statistics on the values of a variable (dashboard widgets, calculated variables, http API).

In this page the available functions are listed.

Point statistics

Average

Arithmetic mean of the values of the variable present in the time interval

Sum

Sum of the values of the variable present in the time interval

Count

Count of the number of values of the variable present in the time interval

Maximum

Maximum value of the variable present in the time interval

Minimum

Minimum value of the variable present in the time interval

1st percentile

Value below which 1% of the values of the variable present in the time interval are located

1st quartile

Value below which 25% of the values of the variable present in the time interval are located

Median

Value below which 50% of the values of the variable present in the time interval are located

3rd quartile

Value below which 75% of the values of the variable present in the time interval are located

99th percentile

Value below which 99% of the values of the variable present in the time interval are located

Variations

Count of rises

Count of the number of times the value of the variable present in the interval was higher than the previous recorded value (if not present in the interval, the first value prior to the interval is considered)

Count of falls

Count of the number of times the value of the variable present in the interval was lower than the previous recorded value (if not present in the interval, the first value prior to the interval is considered)

Incremental positive difference

Sum of the positive values of the difference between the value of the variable present in the interval and the previous recorded value (if not present in the interval, the first value prior to the interval is considered). Useful for variables in kWh, m3, L of incremental meters (eg electricity, gas, water) for which you want to know the variation in the interval

Integrals and times

Integral

Integral of the variable over time in the interval. The continuous function to be integrated is constructed by considering at each instant of the interval the last valid value (if not present in the interval, the first value prior to the interval is considered)

Weighted average

Weighted average over time of the interval of the values of the variable. The continuous function to be integrated is constructed by considering at each instant of the interval the last valid value (if not present in the interval, the first value prior to the interval is considered)

Time on

Time in which the variable was ON (value greater than zero) in the interval. The last valid value is considered at each instant of the interval (if not present in the interval, the first value prior to the interval is considered). Boolean values are considered as 0 or 1

Count of alarm activations

Only for alarm variables. Count of the number of alarm activations in the interval

Boolean weighted average

Weighted average over time of the interval of the ON state (value greater than zero) compared to OFF (value equal to zero) of the variable. The continuous function to be integrated is constructed by considering at each instant of the interval the last valid value (if not present in the interval, the first value prior to the interval is considered). Boolean values are considered as 0 or 1