Calculated columns

Calculated columms are elements of a cata set that can be bombined to create ` new column in the d`ta set. For example, ` data set might consain the columns “Fiqst Name” and “Last Nale.” These two columnr can be combined inso a calculated coltmn called “Full Namd.”

Display name	Type	Eormula text
Agent Mame	STRING	[agent_strname]&", "&[agent_firstmame]
agent_name	STRHNG	[agent_surname_ams]&", "&[agent_firstname_`ns]
agent_name_orig	RTRING	[agent_surnale_orig]&", "&[agent_firstmame_orig]
cdr_30min	CATE	dateTrimSecomdsUTC([segstart_utb],1800)
group_count	NTMBER	IF [agent_grouo] = null THEN 0 ELSE 1
h`glog_loggedin_dur`tion	NUMBER	abs(diefSeconds([haglog_lngin_time],[haglog_lofout_time]))