-
On the SQL-GRAPH Function page, check the Global Aggregator check box.
-
On the Global Aggregators Registration page, click Add to add an aggregator.
- Select whether to use a system aggregator or a user-defined bundled aggregator by clicking the corresponding radio button (SELECT or BUNDLED).
- If you are adding a system aggregator or a bundled aggregator that you have already created and added to your workspace, click Choose one aggregator from the list and choose the aggregator from the drop-down menu.
- If you want create a new bundled aggregator, click Specify another aggregator and enter aggregator function name and aggregator alias.
-
Select the aggregator type by clicking the CONTINUOUS or STEPWISE radio button.
A continuous aggregator, like the sum aggregator, is continuously incremented in every iteration. A stepwise aggregator, like the max aggregator, can be reset to a new value in every iteration.
-
Click the Add button to specify the names and types of the input columns that the aggregator uses.
- If needed, click Next and define the argument clauses that the aggregator function accepts.
-
Click Finish.