Introduction to the aggregation functions

Description

You select an aggregation function, for example, while creating a widget, a report or in the settings for the energy media analysis and the multivariable regression. The aggregation function determines how the values of a parameter are recorded.

  • "Last" outputs the last read value.

    As long as no new value is recorded, the last read value remains valid.

  • Further functions allow you to determine summary information from the read values, such as the sum of all the read values.

The following aggregation functions are available:

Function

Meaning

None

Values are applied unedited as a time series.

If no values are recorded for an analyzed period, no values can be visualized either in the widget.

If too many values are recorded in a selected period, this can lead to undesired results or errors

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).