Adding and Editing Aggregators

You can create new aggregators or edit existing aggregators as needed to meet your business requirements.

1. Select the Aggregator from the drop-down list. This list contains the types of aggregation which are available for this Business Filter, such as Sum, Count or Average Monthly.
2. Enter a Group By clause. This allows you to group aggregators by the specified attribute across the pipeline. Grouping by a certain attribute will be applied to all aggregators used in the pipeline.
3. Select the Attribute from the drop-down list. This list contains the data forge tables and mapped columns.
4. Select the required Look Back option and provide the required Value details. You can further configure the Look Back period for the aggregator when building the expression.
5. Select the Filter Attribute.
6. Select the Filter Operator.
7. Select the required Filter Value option and provide the required details.
8. Add the aggregator using one of the following options. A confirmation message displays.
   • Click Add to add this aggregator to the List of Aggregators.
   • Click Add & Attach to add this aggregator to the List of Aggregators and attach it to the current data set.
9. When you have finished creating aggregators, click Save.