An Average node is a Calculation node that you can use in a policy model to calculate the average value of data in a specified column of a collection.
The input for an Average node must be a collectionA set of results from a Query node or a set of readings associated with input nodes such as Measurement Location, Health Indicator, or OPC Tag. with a column containing numeric or time-based values. The output of an Average node, Value, contains the average value of data in the specified column.
The Properties window for an Average node contains the items that are described in the following table.
Item |
Description |
Notes |
---|---|---|
Collection section |
Specifies the collection that contains the values that you want to average. |
You can select |
Collection Column section |
Specifies the column that contains that values that you want to average. |
This list contains the columns that are available in the selected collection. The column that you select must contain numeric or time-based values. |
The following example illustrates how you can use an Average node to evaluate the readings that are associated with a Health Indicator record and return the average reading value. Consider the following nodes and connection.
As shown in the following image, you can use the Properties window for the Average node to select the Health Indicator node and the Readings option. The Value column of the Readings collection is also selected, indicating that the output of the node is the average of the values in the Value column.
Copyright © 2018 General Electric Company. All rights reserved.