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
Agent Login ID	STRING	text([agls_timestamp_utc]) & " - " & text([agentlogin]) & " - " & text([sequencenumber])
Agent Name	STRING	[agentsurname] & ", " & [agentgivenname]
agent_name	STRING	[agentsurname]&", "&[agentgivenname]
agentname	STRING	[act_agentsurname]&", "&[act_agentgivenname]
agentname	STRING	[abs_agentsurname]&", "&[abs_agentgivenname]
agentname	STRING	[aba_agentsurname]&", "&[aba_agentgivenname]
agentname	STRING	[agp_agentsurname]&", "&[agp_agentgivenname]
Display Name	Type	Formula Text
Event Type Description	STRING	INSPECT [eventtype] CASE "LI" THEN "Log In" CASE "LO" THEN "Log Out" CASE "WW" THEN "Walkaway" CASE "RT" THEN "Return from Walkaway" CASE "RY" THEN "Ready" CASE "NR" THEN "Not Ready" ELSE null
Supervisor Name	STRING	[supervisor_surname]&", "&[supervisor_firstname]
supervisor_name	STRING	[supervisorsurname]&', '&[supervisorgivenname]
supervisorname	STRING	[agp_supervisorsurname]&", "&[agp_supervisorgivenname]
Unique Call ID	STRING	Text([ccmid]) & " - " & Text([contactoriginatedstamp])
Unique CSR Code Stat ID	STRING	text([ccmid]) & " - " & text([code]) & " - " & text([codesequence]) & " - " & text([codestartstamp])