The Aggregate transform allows use of aggregate functions such as SUM, AVG, COUNT, MIN, MAX, etc.

Transform - Aggregate
Transform - Aggregate

1. Input

For example, the input could be a SQL Select transform that corresponds to the following SQL Server table.

The Aggregate transform requires 1 input transform.

2. Configure

In the Aggregate configuration dialog, you must configure the following settings:

  1. Select the columns you do want on the output.
  2. Expand each selected columns and
    • Select the Aggregate function, or
    • Check the "Group By" checkbox if this column is to be used as a grouping column.


Choose the Aggregate Function
Choose the Aggregate Function

Set the Grouping
Set the Grouping

3. Output

The figure below illustrates the output from the Aggregate transform as applied to the SalesOrderDetails table.

SalesOrderDetails SQL table
SalesOrderDetails SQL table

4. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri