Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I just wanted to get the percentage of deparments and employees filling DWR..
Please advise...
Employee_Name | Date | Department | Required Hours | Hours Given |
Henry | 01/21/2020 | HR | 8 | 8 |
Catherine | 01/23/2020 | R&D | 8.5 | 7 |
Karen | 01/24/2020 | Sales | 8.5 | 8 |
William | 01/23/2020 | R&D | 8.5 | 8 |
Mathew | 01/21/2020 | Sales | 8.5 | 7 |
Catherine | 01/25/2020 | R&D | 8.5 | 7 |
William | 01/26/2020 | R&D | 8.5 | 8 |
Mathew | 01/22/2020 | Sales | 8.5 | 8 |
Karen | 01/25/2020 | Sales | 8.5 | 9 |
William | 01/28/2020 | R&D | 8.5 | 7 |
Catherine | 01/27/2020 | R&D | 8.5 | 7 |
Henry | 01/27/2020 | HR | 8 | 8 |
William | 01/30/2020 | R&D | 8.5 | 9 |
Mathew | 01/23/2020 | Sales | 8.5 | 7 |
Henry | 01/25/2020 | HR | 8 | 7 |
Catherine | 01/28/2020 | R&D | 8.5 | 7 |
Mathew | 01/24/2020 | Sales | 8.5 | 8 |
Catherine | 01/29/2020 | R&D | 8.5 | 8 |
Henry | 01/31/2020 | HR | 8 | 8 |
Catherine | 01/30/2020 | R&D | 8.5 | 7 |
Mathew | 01/25/2020 | Sales | 8.5 | 7 |
Karen | 01/29/2020 | Sales | 8.5 | 9 |
Karen | 01/27/2020 | Sales | 8.5 | 7 |
Karen | 01/31/2020 | Sales | 8.5 | 9 |
Mathew | 01/26/2020 | Sales | 8.5 | 7 |
Mathew | 01/27/2020 | Sales | 8.5 | 9 |
Mathew | 01/28/2020 | Sales | 8.5 | 9 |
Mathew | 01/29/2020 | Sales | 8.5 | 9 |
Mathew | 01/30/2020 | Sales | 8.5 | 9 |
Mathew | 01/31/2020 | Sales | 8.5 | 9 |
@sunil-kumar5 can you share also the expected output or the formula you use ?
Hi Taoufiq,
Actually I am not sure as what to use in this case to get the output. But I can explain it further, so this is the daily data filled by the employees like 100 out 500 don't fill their DWR so we can have percentage or numbers as how many employees are not filling it department wise.
Regards,
Sunil
@sunil-kumar5 How do you know that who filled it correctly or not from above data?
Hi Kush, Sorry didn't get the notification for your reply.
The date column is freezed and auto selected, and there is no issue with the hours.
The thing is that I need to provide the percentage of each department as how much they are compliant to filled it on daily basis.
Please advise
So the last column could contain empty values? In that case:
DWR:
Load
Count(Employee_Name),
Department
From YourDataSource Where(IsNum([Given Hours])=0) group by Department;