Cisco Cisco Unified Contact Center Enterprise 9.0(2) User Guide

Right-click the Value field.

Select Argument from the popup menu. This opens a dialog box displaying 
the list of defined arguments. 

Select the argument appropriate for your column. Then click Paste.

As necessary, to add additional Where criteria for the start and end dates, click the 
Logical drop-down list and select AND.

, for an example of a 

Where clause with start_date and end_date arguments.

You can further narrow the scope of the report by adding additional Where 
criteria that do not use arguments.

You can create computed columns in both real-time and historical templates to 
reflect calculations based on the values of two or more database columns. 

You can also insert computed fields when you design the layout in the Report 
Painter. However, computed fields created in the Report Painter do not support 
WebView’s threshold capabilities or dynamic sorting. Computed columns created 
in the SQL Select Painter do.

It is best to create computed columns in the SQL Select Painter and to use the 
Report Painter to modify their formatting, if necessary—for example, by 
changing the format of the query result from seconds to minutes.

Locate the Compute tab at the bottom of the Select Painter. This tab initially 
displays as a blank field.