Adding Summary Calculations
Summary calculations can be added to any CygNet Alarm Manager report or query that has configurable columns. A summary calculation is a calculated value of a column values and is added at the bottom of the report. Valid calculations include:
| Item | Description |
|---|---|
|
Sum |
The sum of all column values. |
|
Average |
The average of all column values. |
|
Min |
The minimum value of all column values. |
|
Max |
The maximum value of all column values. |
All values in the column must be numeric for calculations to be evaluated and displayed properly.
To add a summary calculation to a column, add <SummaryCalc> nodes to the desired <Column> node. For example,
|
<Column filter="System Total" text="Total" > <SummaryCalc>Sum</SummaryCalc> <SummaryCalc>Average</SummaryCalc> <SummaryCalc>Min</SummaryCalc> <SummaryCalc>Max</SummaryCalc> </Column> |
Multiple calculations can be used. As shown in the example above, simply stack the desired calculations.
