Cisco Cisco Unified Contact Center Enterprise 9.0(2) Guida Utente
Chapter 3 Creating New Custom Templates
Create the SQL Statement
3-12
Template Design Guide Using InfoMaker for Cisco ICM/IPCC Enterprise & Hosted Editions, Release 7.0(0)
Step 2
In the Computed Columns field, enter a name for the column followed by an
equal (=) sign. The computed column name cannot contain spaces.
equal (=) sign. The computed column name cannot contain spaces.
Step 3
Right-click to the right of the equal sign. Select Columns from the popup menu.
Step 4
Select the column you want to use and click Paste. This adds the column to the
Computed Columns field.
Computed Columns field.
Step 5
Enter the symbol for the mathematical operation you want to perform (for
example: +, -, /, *).
example: +, -, /, *).
Step 6
To add the next column for the mathematical expression, right-click again in
Computed Columns.
Computed Columns.
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
statement, such as
AvgHandleTime=dbo.t_Service_Half_Hour.HandleTimeToHalf/dbo.t
_Service_Half_Hour.CallsHandledToHalf
.
You might need to edit the query.