Add a summary operation

You can add multiple summary operations for a single summary action, as long as no two summary operations have the exact same configuration.

To add a summary operation

1. In the summary action options, click Add. The Summary Operation Properties dialog box appears.

   

2. In the Calculation Type list, select the type of calculation to be performed: SUM, MAX, MIN, or AVG.

3. In the Time Stamp list, select the timestamp to use when storing the result of the calculation. The timestamp can be either the time when the calculation period starts or ends.

4. In the Resolution box, enter sampling rate, in milliseconds, for retrieving the data in cyclic mode. The system returns values stored over the requested time period at the interval specified by the resolution. For example, if you specify a 5000 ms resolution, the system queries for all data during the time period and then only returns those values that occur at each 5000 ms interval, starting with the start date and ending with the end date.

   In general, the higher the resolution, the more accurate the result, because you are including more values into your aggregation. However, the calculation takes longer and consume more server resources. Avoid very fine resolutions for summary actions associated with schedule detectors that cover long periods of time, such as weekly.

   Resolution is also very useful when calculating SUMS. For example, setting the resolution to 60,000 milliseconds for a flow in gallons per minute automatically produces a result that is the total volume.

5. In the Duration group, select the period for which the calculation must be performed.

   For example, if you are associating a summary action with a duration of 1 hour with a detector that is scheduled for 3:00 a.m. every Monday, then the system performs the aggregation on values stored between 2:00 a.m. and 3:00 a.m. on Mondays.

6. In the Description box, type a description of the summary operation.

7. Click OK.

The new summary operation now appears in the summary action grid.