Defining the Data for a Custom Report
CentreVu CMS Custom Reports
Defining Report Fields
4-20
●
avg
The avg aggregate function retrieves the average of all values found
over the time frame of the report. Using the sample table in
you enter
avg(ACDCALLS)
for a field and run the report for Split 1 for all
intervals on 07/02/95, the value 402.75, which is the average of
399,
400, 394, and 418, is displayed.
count(*)
4
The
count(*)
expression tells
CentreVu CMS to count the number of
rows in a table that match certain row search conditions (as defined in the
Row Search window). For example, if you want the number of agents in a
split that had more than five extension-out calls, the Row Search window
would have a row search statement like:
Select rows where: SPLIT = 1 and
(ACWOAUXOUTCALLS) > 5
This statement means, “Find rows of data where the SPLIT value is
1
and
total extension-out calls, for both ACW and AUX states, is greater than 5."
Then, by entering
count(*)
in the
Select:
field, the report field would
count the number of rows that match, and display the number in your report.
Do not append a table name to the beginning of
count(*)
.
count(*)
is always a number of matching rows and makes sense only if you
want to track some specific measure of performance by ACD elements (for
example, the number of agents currently logged into a split, the number of
trunks that were occupied for more than 80% of the time, the number of
VDNs that had over 30 abandoned calls in an intrahour interval).
count(*)
allows you to create fields that act as exception counts.
Data from More
Than One Table
4
A calculation can merge data from more than one table in a report field.
For example, you may want the percentage of a split's ACD calls that an
agent handled in a day. Thus, you can enter a calculation that merges data
from the Daily Agent and Daily Split tables, as in the following example.
dagent.ACDCALLS/dsplit.ACDCALLS
When you merge data from two tables, you must define your row search
conditions in a special way. See “
Selecting Rows from More Than One Table
”
in
of this manual.
Note
You cannot use calculation names for a field in which you merge data
from two tables, and you cannot merge data in real-time reports.
Summary of Contents for CentreVu
Page 16: ...Preface CentreVu CMS R3V5 Custom Reports Related Documents P 10 ...
Page 44: ...Getting Started CentreVu CMS Custom Reports Deleting a Custom Report 2 10 ...
Page 140: ...Completing Your Custom Report CentreVu CMS Custom Reports Running Custom Reports 5 22 ...
Page 178: ...Database Items and Calculations CentreVu CMS Custom Reports General Information A 2 ...
Page 188: ...Glossary CentreVu CMS Custom Reports GL 10 ...
Page 198: ......
