Aggregate Rows

Owned by Former user (Deleted)
Last updated: Mar 07, 2014 by Former user (Deleted)Version comment

This step is deprecated. See the Group By step for a more powerful way of aggregating rows of data. Just leave out the "Group Field" and the Group by step will aggregate over all rows.

Description

This step type allows you to quickly aggregate rows based upon all the rows. These are the available aggregation types:

  • SUM - the sum of a field
  • AVERAGE - the average of a field
  • COUNT - the number of (not null) values
  • MIN - the minimum value of a field
  • MAX - the maximum value of a field
  • FIRST - the first value of a field
  • LAST - the last value of a field

Note: This step type is deprecated. See the Group By step for a more powerful way of aggregating rows of data. Just leave out the "Group Field" and the Group by step will aggregate over all rows. The aggregate step can be removed in a future version.