Calculate Column Aggregate
Contents
Calculate Column Aggregate
The Column Aggregate Node performs the following statistical functions on a column of data in the Data Table:
- Average
- Sum
- Minimum
- Maximum
- Count
To include this Node in your Task drop a "Calculate Column Aggregate" Task Element into your Task design from the Data Access Task Elements list, after which you will be presented with the following dialog box:
http://www.international-presence.com/wikidocs/images/column_aggregate_dialog.png
There are four configuration options to set for this Node:
- Data Column - Choose the Data Column that you wish to perform the calculation on.
- Aggregate Type - Choose which type of aggregate function you wish to perform
- Variable - The name variable which should store the result
- Variable Scope - see Variables for a description of variable scope.
Average
Statistical mean. This is calculated by adding together all values in the column and dividing the result by the number of records.
Example: The average of 10,15,12,11,19,7,18 is 13.142857
Sum
This is the total of all the values in the data range.
Example: The sum of 10,15,12,11,19,7,18 is 92.
Minimum
This is the lowest value in the data range.
Example: The minimum of 10,15,12,11,19,7,18 is 7.
Maximum
This is the highest value in the data range.
Example: The maximum of 10,15,12,11,19,7,18 is 19.
Count
This is a count of all records.
Non-Numeric values
All non-numeric values will be ignored when calculating these results.
Data Filter | Require Columns | Append Data Column | Multiple Column Appender
Drop Column | Drop Row(s) | Calculate Column Aggregate | Dataset Splitter | Merge Data
Create Data Table | Clear Data Table | Sort Data Table | Drop Duplicate Rows | Store Data Table | Retrieve Data Table
Task Elements > Data Table Nodes > Calculate Column Aggregate