AVG: Average of group
Use the Average of group function in a query or situation to calculate the average from a range of values.
- Average of group
- The AVG function totals the attribute values specified and calculates the average.
- Query example
- This function averages all returned values of % User Time. GROUP
BY is Server Name, so the view will show the average user time, one
row for each managed system.
AVG(% User Time)
- Situation example
- This formula averages all returned values of % User Time. If the
average exceeds 20%, the comparison is true.
AVG (% User Time)> 20