To Create a Time Based Aggregator Operator

1. Drag a Time Based Aggregator operator from the Palette to the Design view.

2. Double-click the Time Based Aggregator operator.

   The property editor opens.

3. In the Start field, enter the time to start calculating the tasks that are to be performed by the Time Based Aggregator within the process.

4. In the Increment field, enter the time increment for the Time Based Aggregator to perform the analysis.

5. In the Size field, enter the time range for the Time Based Aggregator to perform the analysis.

6. In the Expression box, enter the expression for the SQL SELECT statement to specify the input attribute upon which the SELECT is performed. Add attribute names, data types. and sizes, as applicable.

7. In the From box, define the input on which to perform the selection.

8. In the Where clause box, provide additional filtering on records.

   For example:

   WHERE price > 30.00 AND stockDate < '2006-01-01' ;

9. In the Group by box, group a result into subsets that have matching values for one or more columns of the database by specifying a comma-separated list of qualified attribute names.

10. Click OK.