Cisco Cisco IP Contact Center Release 4.6.1 User Guide

To create a computed column:

In the SQL Toolbox, click the Compute tab.

In the Computed Columns field, enter a name for the column followed by an equal 
(=) sign. The computed column name cannot contain spaces.

Right-click to the right of the equal sign and select Columns from the popup menu.

Select the column you want to use and click Paste. The column is entered into the 
Computed Columns field.

Enter the symbol for the mathematical operation you want to perform (e.g., +, -, /, 
*).

Right-click again in Computed Columns and again select Columns from the 
popup menu.

Select a second column to act upon the first and click Paste.

When your computed column is complete, it is added to the list of template 
columns on the left-side of the Sort tab in the SQL Toolbox. 

After completing your template’s SQL statement, you can view the entire statement by 
clicking the Syntax tab in the SQL Toolbox.

An example of a completed SQL statement that includes a computed field 
(AvgHandleTime) and ID, start date, and end date arguments:

SELECT Service.EnterpriseName,   
  Service_Half_Hour.DateTime,   
  Service_Half_Hour.CallsOfferedToHalf,   
  Service_Half_Hour.CallsHandledToHalf,   
  Service_Half_Hour.AvgDelayQToHalf,   
  Service_Half_Hour.HandleTimeToHalf,   
  Service_Half_Hour.ServiceLevelToHalf,   
  Service_Half_Hour.CallsAbandQToHalf,   

AvgHandleTime=Service_Half_Hour.HandleTimeToHalf/Service
_Half_Hour.CallsHandledToHalf  

FROM Service, Service_Half_Hour 

WHERE ( Service.SkillTargetID = 
  Service_Half_Hour.SkillTargetID ) and  
  ( ( Service.SkillTargetID = :servicesList )
  AND
  ( Service_Half_Hour.DateTime >= :start_date ) 
  AND