Onboarding - Processes In Progress Analysis

Onboarding Process/Task Analysis

The analysis consists of two charts.

 

The chart on the left displays # of processes, average percent complete and days in progress by a variety of dimensions,

 

The chart on the right chart displays # tasks, task days in progress and process days in progress by a variety of dimensions.

 The column selector allows you to toggle the dimension for both charts at once.

Report Columns

Name	Syntax
Dimensions	See View By: Dimension
Process Days In Progress	"Submission Transitions Process Time"."Average Submission Transitions Process Days In Progress"
Task Days In Progress	AVG(TIMESTAMPDIFF(SQL_TSI_DAY, "Submission Transitions Process"."Submission Transitions Task Assignment Date" , CURRENT_TIMESTAMP))
Avg Process Percent Complete	avg("Submission Transitions Process"."Submission Transitions Process Percent Complete")
Task ID	"Submission Transitions Process"."Submission Transitions Task Name (BL)" || ' - ' || CAST("Submission General Info"."Submission Identifier" AS CHARACTER) || ' - ' || CAST("Submission Transitions Process"."Submission Transitions Task Creation Date" AS CHARACTER)
# Tasks	"Submission Transitions Process Counts"."# Submission Transitions Tasks"
# Processes	"Submission Transitions Process Counts"."# Submission Transitions Processes"

View By: Dimensions

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",'')
Process Health Is Red	"Submission Transitions Process"."Submission Transitions Process Progression Health Is Red" || Replace("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'')
Process Completion	CASE WHEN "Submission Transitions Process"."Submission Transitions Process Percent Complete" < 25 Then '0-25%' WHEN "Submission Transitions Process"."Submission Transitions Process Percent Complete" < 50 THEN '25-50%' WHEN "Submission Transitions Process"."Submission Transitions Process Percent Complete" < 75 Then '50-75%' WHEN "Submission Transitions Process"."Submission Transitions Process Percent Complete" < 100 Then '75-100%' END || 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 Type	"Submission Transitions Process"."Submission Transitions Task Type" || Replace("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'')
Task Is Overdue	"Submission Transitions Process"."Submission Transitions Task Is Overdue" || Replace("Requisition Identification"."Req. Identifier","Requisition Identification"."Req. Identifier",'')

View Configurations

Name	Additional Information
Bubble	Horizontal Axis: Process Days In Progress XY (Vertical Axis): Avg Process Percent Complete XY (Bubble Size): # Processes Vary Color By: Dimension
Scatter	Horizontal Axis: Task Days In Progress XY (Vertical Axis): Process Days In Progress Vary Color By: Dimension

Report Filters

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