Aggregate Logic Block

Description

The Aggregate Logic Block is used to organize and summarize data over a time interval. It performs a summarizing function to your data over an interval, such as a SUM, or AVERAGE, and maps the summarized data to one point in time within the interval. The aggregation period can range anywhere from several minutes to a year.

It is extremely useful when trying to align data with different measurement times to one common time-stamp (0:15, 0:30, etc.), such that further processing can be accomplished.

Functionality

Input: The Aggregate Logic Block takes input from one logic block. This can be any block that has an output.

Output: The output of the Aggregate Logic Block is a time-aligned summary of your input data.

Available summary functions:

  • Minimum – minimum of all input data over aggregation period
  • Maximum – maximum of all input data over aggregation period
  • Average – average of all input data over aggregation period
  • Sum – sum of all incoming data over aggregation period

Output value time stamps: Time stamp of the output values can also be adjusted to suit your specific needs.

  • Start of Range – data over a time interval is summarized at the front of the time interval
  • End of Range – data over time interval is summarized at the end of the time interval

Block Configuration

Name: Choose the name associated with the Aggregate Logic Block, describing its function within the logic rule.

X-Aggregation: Choose at what time the data over a specific interval is displayed. An example can more easily explain this functionality.

X-Aggregation description

Y-Aggregation: Choose the data summary method used over the time interval. Options are Minimum, Maximum, Average, and Sum Aggregation. Note that the following examples use End of Range X-aggregation

Minimum Aggregation

The Minimum Aggregation algorithm applies the lowest value in an interval to its interval edge.

Maximum Aggregation

The Maximum Aggregation algorithm applies the lowest value in an interval to its interval edge.

Average Aggregation

The Average Aggregation algorithm takes the average of all the data points within the interval, and applies it to the edge of the interval.

Sum Aggregation

The Sum Aggregation algorithm takes the cumulative sum of all the data points within the interval and resets to zero after each interval.

Aggregation Interval: Sets the aggregation time interval to be either user-determined or predetermined.

  • Custom – predetermined aggregation interval, useful when manipulating data for further processing. Custom intervals require additional information when used
  • Request – user-determined aggregation interval, useful when block output is being graphed, such as in a chart

Custom Interval: (Custom Aggregation Interval Only) Sets the duration of an aggregation interval. Options are:

  • Minutes
    • 5 Minutes
    • 15 Minutes
    • 30 Minutes
  • Hourly
  • Daily
  • Weekly (from Monday to Sunday)
  • Monthly
  • Annually

Empty Interval Behaviour: Determines the behaviour of the logic block when no data is being received.

  • No Data Point – passes null when no data is going through the logic block
  • Zero Data Point – passes a zero when no data is going through.

The schematics below demonstrate the functionality of aggregation logic blocks:

30-minute sum
30-minute sum, end of range
One-hour average