Pivot

The pivot is a vizual for tabular representation of historical analyses. Aggregated values of multiple tags can be displayed side by side for comparison.

Aggregation

Depending on the type of the tag, different functions are offered for aggregating the data.

Numeric tags

• Average
• Sum
• Min
• Max

Counter tags

• Current count: Interpolated counter reading at the beginning of the time interval.
• Current count (Min): Smallest measured counter reading of the time interval.
• Current count (Max): Largest measured counter reading of the time interval.

Logic tags

• Average: Percentage of how long the value was active within the time interval.
• Sum: Operating hours within the time interval.
• Active count: Number of measurements with TRUE value.
• Active days count: Number of days that have at least one measurement TRUE.
• Change count: Number of changes TRUE and FALSE.

Comparison function

In addition to the values for the current time range, an additional column with the previous time range can be displayed using the Comparison column option. If, for example, the year 2023 is selected in the pivot, the comparison column contains the months of the year 2022. You can also display the absolute or percentage difference.

Interaction with the pivot

The time range can be selected within the pivot. This can be done either via the time range selection or by clicking on a cell with a time range. The tag information can be opened via the individual cells.