Description
The Aggregate node is used to calculate a set of aggregates from the preceding node.
Configuration Options
Basic Configuration Options
| Setting |
Description\Parameters |
Group By |
This drop down includes the set of columns from the preceding node. Defaults to none. Any columns selected here will be part of the GROUP BY for the selected aggregate functions. |
Options |
This drop down includes the set of aggregate functions to be applied to the Group By columns. Each function checked will generate a new column in the node output. |
Actions
| Action |
Description |
Reset All |
Reset all aggregate options. |
Preview |
After configuring the node, the combined result set can be previewed by clicking the Preview button. |