Lucent Technologies CentreVu Call Management System Custom Reports Manual

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining Report Fields4-23
StringSelect String for those database items whose data 
CentreVu CMS identifies as character strings, not numbers. 
(Each of these items is identified as being a CHAR column 
type in 
INFORMIX terminology.) Even though these items 
store numbers, 
CentreVu CMS searches for values as if the 
items stored nonnumeric symbols and alphabetic words, as 
well as numbers.
Database items for which you might select...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining Report Fields4-24
Table 4-3:  Synonym Types for Report Fields
Report Field Type Database Item
ACD Entitiesacd
agname
tkgrp
split
vdn
a
vectora
aux_rsn
logout_rsn
cwc
a. Available only with the CentreVu CMS Vectoring feature.
ACD
LOGID
TKGRP
SPLIT
b
VDN
VECTOR
AUXREASON
LOGOUTREASON
CWC
b. Contains skill or split values.
Agent Statesworkmodec
ag_origd
ag_dir
ag_dest
ag_pref
c. Applies to the WORKMODE database item in both the...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining Report Fields4-25
Time 
(duration)Select Time (duration) if the field expression will 
display a length of time. You must also enter a time format 
with the appropriate punctuation.
Durations (for example, ACDTIME) are stored as a number of 
seconds. However, you can choose to display time as 
minutes and seconds, or even hours, minutes, and seconds.
The time formats available are:
Table 4-4:  Time Formats for Report Fields...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining Report Fields4-26
Time 
(point in 
time)Select Time (point in time) if the field expression will 
display a point in time (for example, 10:34am). Enter a time 
format with the appropriate punctuation.
You can use one of the following formats:
Table 4-5:  Point-In-Time Formats for Report Fields
HHThe hour only, in military time (24-hour 
clock). For example, 15 equals 3:00 p.m.
hhThe hour only, according to a 12-hour 
clock. For...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining Bars in a Report4-27
Step 6: Save 
the Field 
Definition
4
To define additional fields, repeat steps 1 through 6.
Changing a 
Field 
Definition
4
Defining Bars in a Report4
Select the Save action list option.®The Field window disappears, 
and Successful 
appears in 
the Screen Painters status line 
to indicate the field definition 
has been added.
NoteYou must assign a Row Search ID to the field before your field 
definition is...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining Bars in a Report4-28
You may want a report to display data as bar graphs instead of numbers. 
Defining a bar or bars in a report is similar to defining fields, except in the 
way you define the format. To define a bars format, you must specify the 
following items:
lThe position and length of the bar
lThe direction of the bar — horizontal or vertical
lThe thresholds that cause the bar to change color
lThe scale of the bar.
What...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining Bars in a Report4-29
Figure 4-7:  The Bar Window (with Sample Input) 1b.Move the cursor using the arrow 
keys to define the length and 
width of the bar, and press 
. ®
A question mark (?) appears 
in the upper left corner of the 
bar. The question mark 
indicates that you have not yet 
assigned a Row Search ID to 
the bar. 
The Bar window also appears.
Return 

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining Bars in a Report4-30
Step 2: Define 
the Bars Data 
Expression
4
Enter a data expression in the Select field to tell CentreVu CMS two 
things:
lWhat table column(s) should supply data to the bar
lHow to manipulate that data.
The rules for this Select field are identical to those of the Select field 
for the Field window. However, the following types of database items do not 
make sense for bars:
lIdentifiers (for example, SPLIT,...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining Bars in a Report4-31
Step 5: Define 
the Bar Scale
4
Enter an x to select an option in the Scale list.
lScale with tick marks
The scale appears in the report as a line, segmented by evenly spaced 
marks (see Figure 4-8
). For a vertical scale, a tick mark appears for 
each vertical character space. For a horizontal scale, a tick mark 
appears at every fifth horizontal character space.
lScale without tick marks
The scale...

  Defining the Data for a Custom Report CentreVu CMS Custom Reports
Defining Bars in a Report4-32
Figure 4-8:  Bars — With and Without Scales
 
04/19/95 00:30 AM CentreVu(TM) CMS Windows: 2 of 5 ^ 
Custom Reports: Historical: split status
Tick
MarkScale With
Tick MarksScale Without
Tick MarksBar With
No Scale
% Within
Service LevelACD CallsAbandons
Row 1 Col 1