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 |
---|---|---|
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") |