Calculated columns
Calculated columns are elements of a data set that can be combined to create a new column in the data set. For example, a data set might contain the columns “First Name” and “Last Name.” These two columns can be combined into a calculated column called “Full Name.”
|
Display name |
Type |
Formula text |
|---|---|---|
| acd_hold_count | NUMBER | if([aqd_holdtime]>0,[aqd_callcount],0) |
| acd_rna | NUMBER | if(and([aqd_ringtime]>0,[aqd_talktime]=0),1,0) |
| agent_name | STRING | [resourcelastname]&", "&[resourcefirstname] |
| agent_name | STRING | [resourcelastname]&", "&[resourcefirstname] |
| aqd_handle_time | NUMBER | [aqd_talktime] + [aqd_holdtime] + [aqd_worktime] |
| asd_login_count | NUMBER | if([eventtype_code_value]=7,[eventcount],0) |
| asd_login_duration | NUMBER | if([eventtype_code_value]=7,[event_duration],0) |
| asd_notready_count | NUMBER | if([eventtype_code_value]=2,[eventcount],0) |
| asd_notready_duration | NUMBER | if([eventtype_code_value]=2,[event_duration],0) |
| ccd_calls_abandoned | NUMBER | if([contactdisp_code_value]=1,1,0) |
| ccd_calls_abandoned_connecttime | NUMBER | if([contactdisp_code_value]=1,[connecttime],0) |
| ccd_calls_handled | NUMBER | if ([contactdisp_code_value]=2,1,0) |
| ccd_calls_handled_connecttime | NUMBER | if ([contactdisp_code_value]=2,[connecttime],0) |
| cqd_calls_abandoned | NUMBER | if([disposition_code_value]=1,[queuecount],0) |
| cqd_calls_dequeued | NUMBER | if ([disposition_code_value]=3,[queuecount],0) |
| cqd_calls_handled | NUMBER | if ([disposition_code_value]=2,[queuecount],0) |
| cqd_metservicelevel_calls_abandoned | NUMBER | if([disposition_code_value]=1,[metservicelevel],0) |
| cqd_metservicelevel_calls_handled | NUMBER | if([disposition_code_value]=2,[metservicelevel],0) |
| cqd_time_abandoned | NUMBER | if([disposition_code_value]=1,[queuetime],0) |
| cqd_time_before_handled | NUMBER | if ([disposition_code_value]=2,[queuetime],0) |
| Date | DATE | dateTrim([asd_event_startdatetime],"DayOfMonth") |
| Date | DATE | dateTrim([aqd_acd_startdatetime],"DayOfMonth") |
| Date | DATE | dateTrim([ccd_acd_startdatetime],"DayOfMonth") |
| Date | DATE | dateTrim([cqd_call_startdatetime],"DayOfMonth") |
| dest_orig_resource_loginid | STRING | # if([desttype_code_value]=1,[dest_resourceloginid],if([origtype_code_value]=1,[orig_resourceloginid],null)) [dest_resourceloginid] |
| dest_resource_full_name | STRING | [dest_resourcelastname]& ", "&[dest_resourcefirstname] |
| disposition_code_desc_acd_correction | STRING | IF [disposition_code_desc] = null THEN "Not Queued to CSQ" ELSE [disposition_code_desc] |
| orig_resource_full_name | STRING | [orig_resourcelastname]&", "&[orig_resourcefirstname] |
| resource_full_name | STRING | [resourcefirstname] & " " & [resourcelastname] |