Cisco Cisco Unified Contact Center Enterprise 10.0(1) Technical References
3-11
Template Design Guide Using InfoMaker for Cisco Unified ICM/Contact Center Enterprise & Hosted Editions, Release 8.0(1)
Chapter 3 Creating New Custom Templates
Create the SQL Statement
Step 7
Select a second column to act upon the first and click Paste.
Creating the computed column using the SQL Select Painter results in a basic statement, such as
AvgHandleTime=dbo.t_Service_Half_Hour.HandleTimeToHalf/dbo.t_Service_Half_Hou
r.CallsHandledToHalf
r.CallsHandledToHalf
.
You might need to edit the query.