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. Image showing a bubble chart

Report Columns

The report shows report columns and syntax if any
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

The report shows graph dimensions 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",'')`
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

The report shows graph 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

The report shows 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