Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
sunil-kumar5
Creator II
Creator II

Daily Work Report

Hi Community,

Please find the below sample data. This is a daily work report (DWR) for employees from different departments. I have taken 11 days sample data from 01/21/2020 to 31/01/2020. This is really important to fill DWR on daily basis however few employee don't fill it timely and missed days. 

First wanted to get the percentage of compliant and non compliant employees  whether they are filling the DWR on daily basis or not. 

Second there is a required hours column which has 8.5 and 8 hours depending on departments along with that there is a another column of worked hours, so on the basis on that I want to calculate the men hours utilization.

Please advise...

Employee_NameDateDepartmentRequired HoursHours Given
Henry01/21/2020HR88
Catherine01/23/2020R&D8.57
Karen01/24/2020Sales8.58
William01/23/2020R&D8.58
Mathew01/21/2020Sales8.57
Catherine01/25/2020R&D8.57
William01/26/2020R&D8.58
Mathew01/22/2020Sales8.58
Karen01/25/2020Sales8.59
William01/28/2020R&D8.57
Catherine01/27/2020R&D8.57
Henry01/27/2020HR88
William01/30/2020R&D8.59
Mathew01/23/2020Sales8.57
Henry01/25/2020HR87
Catherine01/28/2020R&D8.57
Mathew01/24/2020Sales8.58
Catherine01/29/2020R&D8.58
Henry01/31/2020HR88
Catherine01/30/2020R&D8.57
Mathew01/25/2020Sales8.57
Karen01/29/2020Sales8.59
Karen01/27/2020Sales8.57
Karen01/31/2020Sales8.59
Mathew01/26/2020Sales8.57
Mathew01/27/2020Sales8.59
Mathew01/28/2020Sales8.59
Mathew01/29/2020Sales8.59
Mathew01/30/2020Sales8.59
Mathew01/31/2020Sales8.59
1 Reply
sunil-kumar5
Creator II
Creator II
Author

Can anyone please help on this?