Troubleshooting guide

February 2006 117
Choose functions for the SELECT items window
Use the Query Assistant window to assign AVG, MAX, MIN, and SUM aggregate
functions to the Query Items.
This section includes the following topics:
● Definition of function on page 117
● Types of functions on page 117
Definition of function
A function is a prefix that is attached to a database item, a calculation, parts of a
calculation, or a calculation name. Avaya CMS will display only one value on the report if a
SUM, AVG, MIN, or MAX aggregate function is assigned to a database item or calculation.
Types of functions
The available aggregate functions are described in the following table.
Aggregate
function
Description
MAX Retrieves the highest value for a calculation or database item over the
time frame of the report
MIN Retrieves the lowest value for a calculation or database item over the
time frame of the report
SUM Retrieves the sum of all values for a calculation or database item over
the time frame of the report
AVG Retrieves the average of all values found over the time frame of the
report