Hi, Prepare date wise summary for emplyees not sending attendance by department

[AshishTanwar88]

Hi,

I need help preparing a summary report for employees' attendance by the department. I have two tables Employee and Daily attendance. The employee table has the department Name and EmployeeId And the other table contains the daily entry of the present employee for each day. I need to prepare a summary report for each day and each department with the count of employees not present on the given date. I am attaching a picture of the table structure and the final required report. Please provide some guidance to fulfill my requirements. Thanks a lot.

[danextian · Accepted solution]

hi @AshishTanwar88

1. Create ane to many relationship from DepartmentTable[EmployeeID] to EntryTable[EmployeeID]
2. Create a measure that counts the records of entry table COUNTROWS (EntryTable)
3. Select Matrix viz and add EntryTable[Date] and  DeparmentTable[DepartmentName] to row tile and the measure to the value tile

Please see screenshots of a sample below:

[AshishTanwar88]

Thanks a lot, @danextian , This is exactly what I was looking for 🙂