Calculation of indicator

Using the stored configuration and the indicator formula, data for the specified time range are calculated and stored in the relevant measured variable. If a measured variable with an interval greater than the indicator interval is specified in the formula, the OBIS measured-variable function determines how the values are handled. When using the “Sum” function, the values are broken down to the smaller indicator interval. With other functions, the values are used as constants in the indicator interval. The time range must be specified for the calculation. A user-defined completion trigger can be fired.

The workflow applies only to the “Indicator” metering point type.

Where can I find this workflow?

Evaluation section => Indicator => Automation

Parameters

Time span

Defines how the time span of the action is determined.

  • Latest: The time elapsed between the last record and the time of execution.
  • Complete: The entire time span, starting from the timestamp of the first record.
  • Number of days: Full days in the past, counting from the time of execution.
  • Time range: Specify the start and end times precisely.

Last [Export / Calculation] date

The timestamp of the record processed by the last successful operation. Only active if “Latest” is selected as the time span.

Days

Number – Specifies the number of days for which the data request is carried out in the past. Starts at the time of execution.

Only active if “Number of days” is selected as the time span.

Time range

Start date / End date – Specifies the time range during which the action is to be carried out. Only active if “Time range” is selected as the time span.

Start

Defines the point in time to which the offset is applied. Set the date to ...

  • Hour: ... the date and time of execution.
  • Day: ... the date of execution and the time to 00:00.
  • Week: ... the preceding Monday relative to the execution date and the time to 00:00.
  • Month: ... the first day of the execution month and the time to 00:00.
  • Year: ... 1 January of the execution year and the time to 00:00.

Offset

Specifies the offset into the past for the date resulting from “Start”.

Duration

Determines the end date from the specified duration, starting from the start date calculated from “Start” and “Offset”.

Completion trigger

Trigger – Specifies the trigger that is executed once the workflow has finished.

Version

Date

Change

2.9

03/06/2024

FIX: Enabled target interval “Hour” Avoided invalid date/time values during daylight-saving transitions

2.8

03/02/2022

Limited start date for the “newest” function

2.7

03/03/2021

FIX: Rows with constant values written

2.6

02/22/2021

FIX: LastValidationDate variable saved

2.5

01/20/2021

FIX: Corrected calculation of time periods

2.4

01/14/2021

FIX: Incorrect calculation with timerangechoice “dynamic”

2.3

06/03/2020

FIX: Termination due to missing data

2.2

05/03/2020

UPDATE: Larger intervals are broken down to smaller intervals when using the “Sum” measured-value function With other functions, the value is used as a constant for each interval.

2.1

04/20/2020

FIX: “full” time range function failure with an exception

2.0

03/04/2020

Workflow created