The Aggregator operator calculates data aggregations on the input data. It provides an output row set that contains the aggregated data.
Aggregator operator is the “group by” clause in Sql.
You can define in the properties :
- the group by clause
- the having clause
To define an aggregate formula, you have to click in the column of the output group, goes to the properties and put your formula in the expression.