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