Calculate Column Aggregate

From PresenceWiki
Revision as of 05:52, 15 July 2010 by Admin (Talk | contribs)

Jump to: navigation, search

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