Cisco Cisco Unified Contact Center Enterprise 10.0(1) User Guide

Page of 138
 
A-15
Template Design Guide Using InfoMaker for Cisco ICM/IPCC Enterprise & Hosted Editions, Release 7.0(0)
Appendix A      Creating Sample Report Templates
Sample Historical Template
The Table Layout screen now contains two tables.
c.
Add columns from these two tables follows:
From the 
Service
 Table, locate and select 
EnterpriseName
.
From the 
Service_Half_Hour
 table, locate and select these seven 
columns:
DateTime
CallsOfferedToHalf
CallsHandledToHalf
CallsAbandQToHalf
ServiceLevelToHalf
AvgDelayQToHalf
HandleTimeToHalf
d.
Note that the columns appear across the top of the tables. 
Step 3
Specify the Retrieval Argument and Where clause as follows:
a.
From the InfoMaker toolbar, select Design > Retrieval Arguments.
b.
At the Specify Retrieval Arguments dialog box, enter these three retrieval 
arguments:
– list_of_persvc
 with Type 
Number array. 
Click Add.
– start_date
 with Type 
DateTime
. Click Add.
– end_date
 with Type 
DateTime