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 |
|---|---|---|
| aed_event_name | STRING | if([aed_event]=1,"LOGIN",if([aed_event]=2,"LOGOUT",if([aed_event]=3,"NOT_READY","UNKNOWN"))) |
| aed_login_duration | NUMBER | if([aed_is_logout]=1,[aed_event_duration],0) |
| aed_notready_duration | NUMBER | if([aed_is_notready]=1,[aed_event_duration],0) |
| agent | STRING | [person_lastname]&", "&[person_firstname] |
| Agent Name | STRING | [person_lastname]&", "&[person_firstname] |
| call_type_date | DATE | dateTrim([call_type_utc_interval_ts],"DayOfMonth") |
| rcd_utc_routing_15min | DATE | dateTrimSecondsUTC([rcd_utc_routing_ts],900) |
| skillgroup_name | STRING | let [sg]=[skillgroup_enterprisename] let [pos]=findLast(".",[sg]) if([pos]=0,[sg],right([sg],len([sg])-[pos])) |
| tcd_callshandled | NUMBER | if([calldisposition]=13,[tcd_count],0) |
| tcd_utc_call_15min | DATE | dateTrimSecondsUTC([tcd_utc_call_ts],900) |