Measuring the Completeness of Onboarding Task by Employee
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