I have daily work report data where employee fill their daily task, so its obivious that there will be multiple entries per day. I have their name, EMPID, Department,date,task name etc..
I wanted to check how every department is compliant to fill it on daily basis, monthly basis and what is the compliance % of filling the data.
