Boolean values are interpreted in calculations as numeric values 0 and 1.
- Sum
Returns the sum of the numeric values for the calculation period. - Count
Returns the number of values within the calculation period. - Average
Returns the arithmetic average of numeric values for the calculation period.
All values are weighted the same. The result can be a floating-point number. - Min
Returns the lowest numeric value within the calculation period. - Max
Returns the highest numeric value within the calculation period. - First
Returns the first value within the calculation period. - Last
Returns the last value within the calculation period. - Counter
Returns the summed value changes of numeric values within the calculation period.
With an up counter, only positive value changes are summed. Negative value changes are interpreted as a counter reset.
In the case of a down counter, positive and negative value changes are summed.
More precise settings can be made at the variable via the counter settings. - Step duration
Indicates how long the variable has a value and is thus not equal to 0.
Time that the variable actively supplies values. - Timer
Returns the time during which a value was not "false" (FALSE, NULL or empty string). - Time weighted average
Returns the time-weighted average of numeric values for the calculation period.
The values are weighted differently, depending on how long they have been present. The longer a value was present, the more it is weighted. - Standard deviation
Returns the standard deviation of numeric values within the calculation period. -
Variance
Returns the variance of numeric values within the calculation period. -
EnergyToPower
A consumption value is converted to power.
This aggregation function can only be selected in combination with the acquisition category consumption value (Energy) and Counter. - PowerToEnergy
Power is converted to a consumption value.
This aggregation function can only be selected in combination with the acquisition category power value (Power). - AmountToFlow
An amount value (per hour) is directly converted to a flow value.
This aggregation function can only be selected in combination with the acquisition category amount value (Amount) and Counter. - FlowToAmount
A flow value (amount/h) is converted to a quantity value.
The function calculates an estimated value for the upcoming period based on the current flow value.
This aggregation function can only be selected in combination with the acquisition category flow value (Flow).