Description
The Offset Logic Block outputs past or future data of an input data series. It takes data from an input trend log and updates the time stamp to a more recent date, or to a future date. This does not change the data values but rather moves the time stamps forward or backward by a specified amount of time. This block is most useful when historic baselines are required.
Note: It is possible to ask for invalid data. An example is data for March 30 and OFFSET (1 month) tries to get data for Feb 30. Feb 30 does not exist and the logic flow will return no value.
Functionality
The Offset Logic Block is extremely useful when comparing the performance of an object against its historical performance, or the historical performance of another object.
Input: The Offset Logic Block takes as input raw or modified data from a Trend Log.
Output: The output of the Offset Logic Block is the same as the input data series, with the time stamps advanced such that they reflect the block set-up parameters. Note that no data manipulation occurs in this Logic Block, it is simply moving the time stamps forward or backward.
Block Configuration
Name: Choose the name associated with the Offset Logic Block, describing its function within the logic rule.
Amount of Offset: Select the amount of the offset in the range of -999 to 999. Positive number shifts data forward in time; negative numbers shifts data backward in time.
Date Interval: Select the units used to offset the data. Options are:
- Minutes
- Hours
- Days
- Weeks
- Months This can have an issue of no data returned, due to date not existing
- Years This can have an issue of no data returned, due to date not existing
