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”.

Data as of 20 May 2022

Display name

Type

Formula text

Absence Full Day NUMBER IF AND([absence_id]<>-1 , [day_off_id]=-1) THEN 1 ELSE 0
Absence Status STRING IF ([is_deleted] , "Deleted", "Active")
Absence Type STRING if [absence_name]='Not Defined' then '*Activities' else [absence_name]
Active Agent Skill STRING if([active],"Yes","No")
Active/Deleted Record STRING IF ([is_deleted], "Deleted record", "Active record")
Active/Deleted Record STRING IF ([is_deleted]=1 , "Deleted record", "Active record")
Active/Deleted Record STRING IF ([is_deleted] , "Deleted record", "Active record")
Active/Deleted Record STRING IF ([is_deleted] , "Deleted record", "Active record")
Active/Deleted Record STRING IF ([is_deleted] , "Deleted record", "Active record")
Active/Deleted Record STRING IF ([is_deleted], "Deleted record", "Active record")
Active/Deleted Record STRING IF ([is_deleted], "Deleted record", "Active record")
Active/Deleted Record STRING IF ([is_deleted] , "Deleted record", "Active record")
Active/Deleted Record STRING IF ([is_deleted], "Deleted record", "Active record")
Active/Deleted Record STRING IF ([is_deleted] , "Deleted record", "Active record")
Active/Deleted Record STRING IF ([is_deleted] , "Deleted record", "Active record")
Active/Deleted Record STRING IF ([is_deleted], "Deleted record", "Active record")
Active/Deleted Record STRING IF ([is_deleted] , "Deleted record", "Active record")
Active/Deleted Record STRING IF ([is_deleted] , "Deleted record", "Active record")
Active/Deleted Record STRING IF ([is_deleted] , "Deleted record", "Active record")
Activity Status STRING IF([is_deleted],"Deleted","Active")
Activity Type STRING if [activity_name]='Not Defined' then '*Absences' else [activity_name]
Agent Handling Time (hh:mm:ss) NUMBER [after_call_work_time_s] + [talk_time_s]
Agent Handling Time (s) NUMBER [after_call_work_time_s]+[talk_time_s]
Agent Has Skill STRING if([has_skill]=1,"Yes","No")
Agents Ready NUMBER IF [ready_time_s]>0 THEN [acd_login_id] ELSE NULL
Days Off NUMBER IF [day_off_id]<>-1 THEN 1 ELSE 0
Default Scenario NUMBER if([default_scenario],1,0)
Forecasted Time Skill (hh:mm) NUMBER [forecasted_resources_m]*60
Forecasted Time Skill incl Shrinkage (hh:mm) NUMBER [forecasted_resources_incl_shrinkage_m]*60
Late for Work Count NUMBER IF(ifNull([seconds_late_for_work],0)>0,1,0)
Overtime Type Status STRING IF ([is_deleted] , "Deleted", "Active")
Requested Time (s) NUMBER #REQUESTED TIME SHOULD ONLY BE COUNTED FOR WHEN ABSENCE OR OVERTIME REQUEST INSPECT [request_type_id] CASE 1 THEN [requested_time_m]*60 #ABSENCE CASE 4 THEN [requested_time_m]*60 #OVERTIME ELSE NULL #TEXT OR SHIFTTRADE
Scenario Name (Business Unit) STRING [scenario_name]& " " & "("&[business_unit_name]& ")"
Scenario Status STRING if([is_deleted],"Deleted","Active")
Schedule vs Forecast Intraday Deviation (hh:mm) NUMBER [intraday_deviation_m]*60
Scheduled Contract Absence Time (s) NUMBER [scheduled_contract_time_absence_m]*60
Scheduled Contract Time (s) NUMBER [scheduled_contract_time_m]*60
Scheduled Overtime (s) NUMBER [scheduled_over_time_m]*60
Scheduled Paid Time (s) NUMBER [scheduled_paid_time_m]*60
Scheduled Ready Time sec NUMBER [scheduled_ready_time_m]*60
Scheduled Time (s) NUMBER [scheduled_time_m]*60
Scheduled Time Skill (hh:mm) NUMBER [scheduled_resources_m]*60
Scheduled Work Time (s) NUMBER [scheduled_work_time_m]*60
Shift Category Status STRING IF ([is_deleted],'Deleted','Active')
Shifts Count NUMBER IF [shift_category_id]>0 THEN 1 ELSE 0
Skill Status STRING IF([is_deleted],"Deleted","Active")
use_bridge NUMBER 1
use_bridge NUMBER 1
use_bridge NUMBER 1
Workload Status STRING if([is_deleted], "Deleted","Active")