The Aggregate transform allows use of aggregate functions such as sumaveragecountminimummaximum, etc.

Transform - Aggregate
Transform - Aggregate

1. Input

The Aggregate transform requires one input transform.

2. Configure

The transform will initially be configured to group by all non-numeric columns and sum the numeric columns.

Un-check the checkboxes for any columns you want to exclude from the output, and click to expand the remaining columns to configure them.

Choose the aggregate gunction
Choose the aggregate gunction

For columns that are selected for output, either set Aggregate Function, or check Group By.

Group by un-aggregated columns
Group by un-aggregated columns

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.
400-15 Gervais Drive
Toronto, ON, Canada
M3C 1Y8

North America: 1.800.463.1492
International: 1.416.467.5100

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