Introduction to the aggregation functions

Description

You use an aggregation function to select which value is to be output for a variable.

  • Output the last read value with "Last".

  • Use the other functions to gather summary information from the read values, for example, the sum of all read values.

The following aggregation functions are available:

Function

Meaning

Average

Calculates the time-weighted average value of the read values.

Min

Outputs the smallest read value.

Max

Outputs the largest read value.

Sum

Adds all read values.

Last

Outputs the last read value.

Counter

The sum of the positive value changes between two points in time is output in each case.

Timer

The Timer calculates the time interval in which the variable was not 0. Unit = milliseconds.

EnergyToPower

A consumption value can be converted into power.

This aggregation function can only be selected in combination with the acquisition category consumption value (Energy) and Counter.

PowerToEnergy

Power can be converted into a consumption value.

This aggregation function can only be selected in combination with the acquisition category power value (Power).

AmountToFlow

An amount (per hour) can be converted directly into 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) can be converted directly into an amount value.

This aggregation function can only be selected in combination with the acquisition category flow value (Flow).

NOTE

Activating the interval in the first step of the Widget wizard

For this function to be executed, the aggregation function of the variable must not be set to "None" because the values are displayed directly in the widget without further processing in this case.