Onboarding - Tasks Completed Time

This chart shows the number of tasks that have been completed, as well as the expected completion time and the average completion time in days.

Time To Complete Tasks

Report Columns

This table shows graph columns and syntax if any

Name	Syntax
Dimensions	See View By: Dimension
Submission Transitions Task Name (BL)	"Submission Transitions Process"."Submission Transitions Task Name (BL)"
Avg Completion Days	AVG(TIMESTAMPDIFF(SQL_TSI_DAY, "Submission Transitions Process"."Submission Transitions Task Assignment Date" , "Submission Transitions Process"."Submission Transitions Step End Date"))
Avg Expected Days	AVG(TIMESTAMPDIFF(SQL_TSI_DAY, "Submission Transitions Process"."Submission Transitions Task Assignment Date" , "Submission Transitions Process"."Submission Transitions Task Due Date"))
# Tasks	"Submission Transitions Process Counts"."# Submission Transitions Tasks"
Total Time Spent	SUM(TIMESTAMPDIFF(SQL_TSI_DAY, "Submission Transitions Process"."Submission Transitions Task Assignment Date" , "Submission Transitions Process"."Submission Transitions Step End Date"))

View By: Dimensions

This table shows dimension columns and syntax if any

Name	Syntax
Organization	"Requisition Organization"."Organization Level1 Name"
Country	"Requisition Primary Location"."Location Level1 Name"
Category	"Requisition Job Field"."Job Field Level1 Name"
Department	"Requisition Department"."Department Name"
Hiring Manager	"Requisition Hiring Manager"."Hiring Manager Name"
Process Name	"Submission Transitions Process"."Submission Transitions Process Name (BL)" || Replace("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'')
Process Owner	"Submission Transitions Process"."Submission Transitions Process Owner Full Name" || Replace("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'')
Task Name	"Submission Transitions Process"."Submission Transitions Task Name (BL)" || REPLACE("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'')
Task Assignee	"Submission Transitions Process"."Submission Transitions Task Assignee Name" || Replace("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'')
Task Assignee Department	"Submission Transitions Process"."Submission Transitions Task Assignee Department" || Replace("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'')
Task Type	"Submission Transitions Process"."Submission Transitions Task Type" || Replace("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'')
Process Complete Period	EVALUATE('TO_CHAR(%1,%2)' AS CHARACTER,"Submission Transitions Process"."Submission Transitions Process End Date",'YYYY-MM') || Replace("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'')

View Configurations

This table shows graph configuations

Name	Additional Information
Table	Columns and Measures: Dimension, # Tasks, Avg Completion Days, Avg Expected Days, Total Time Spent
Column-Line	Bars: # Tasks Lines: Avg Completion Days, Avg Expected Days Group By: Dimension
Stacked Total Time By Task	Bars: Total Time Spent Vary Color By: Submission Transitions Task Name (BL) Group By: Dimension

Report Filters

This table shows report filters

Name
Submission Transitions Task Current Status is equal to / is in Completed
Submission Transitions Process Type is equal to / is in New Hire
Submission Transitions Process Current Status is equal to / is in Completed
Onboarding - Dashboard Prompt Listener