Difference between revisions of "Calculate Column Aggregate"
Line 1: | Line 1: | ||
== Calculate Column Aggregate == | == Calculate Column Aggregate == | ||
+ | |||
+ | This document has been revised for Presence version 3.6. | ||
The Column Aggregate Node performs the following statistical functions on a column of data in the [[Data Table]]: | The Column Aggregate Node performs the following statistical functions on a column of data in the [[Data Table]]: | ||
Line 21: | Line 23: | ||
* '''Variable''' - The name variable which should store the result | * '''Variable''' - The name variable which should store the result | ||
* '''Variable Scope''' - see [[Variables]] for a description of variable scope. | * '''Variable Scope''' - see [[Variables]] for a description of variable scope. | ||
− | + | * '''Rules''' - set the [[Rules]] for runtime evaluation. | |
=== Average === | === Average === |
Revision as of 06:52, 15 July 2010
Contents
Calculate Column Aggregate
This document has been revised for Presence version 3.6.
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.
- Rules - set the Rules for runtime evaluation.
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