You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Measuring the Completeness of Onboarding Task by Employee

Received Response
11
Views
2
Comments
edited Nov 3, 2023 7:58PM in Journeys 2 comments

Summary: Measuring of Completeness of Onboarding Task by Employee


Content (please ensure you mask any confidential information): In the Onboarding report use the Checklist subject area, and try to determine the completeness of Onboarding tasks by Employee at 5 days from the allocation date. I am using below CASE statement below in the Completion field but seems to be not effectively working with all use cases. For example: there are 5 tasks completed by employee within 5 days of allocating the tasks, only TWO tasks are showing as GREEN and other as RED as per the below statement.

CASE WHEN "Checklist Task Details"."Status"= 'Completed' AND ("Checklist Task Template"."Task Name" IN ('Company Text Alert', 'Complete Trainings')) AND (TIMESTAMPDIFF(SQL_TSI_DAY, "Allocated Checklist"."Allocation Date" ,"Checklist Task Details"."Actual End Date")<=5) THEN 'GREEN' ELSE 'RED' END

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!