[{"_id":ObjectId("5d7f2eefcb072306dd7e67a5"),"Emp No":"0088P2C","Emp Name":"MANISHA JHA","Card No":"2076","Department":"THBS","Att Date":"03-Jun-2019","In Time":"03-Jun-2019 10:53","Out Time":"03-Jun-2019 18:13","Status":"P ","Late By ":"01:53","Early By ":"00:00","Total Hour":"07:20","OT Hour":"00:00","Location":"Consolidated","id":"A10088P2C-03-Jun-2019"},{"_id":ObjectId("5d7f2eefcb072306dd7e67a6"),"Emp No":"0088P2C","Emp Name":"MANISHA JHA","Card No":"2076","Department":"THBS","Att Date":"04-Jun-2019","In Time":"04-Jun-2019 09:50","Out Time":"04-Jun-2019 15:33","Status":"O ","Late By ":"00:50","Early By ":"02:27","Total Hour":"05:43","OT Hour":"00:00","Location":"Consolidated","id":"A10088P2C-04-Jun-2019"},{"_id":ObjectId("5d7f2eefcb072306dd7e67a7"),"Emp No":"A10088P2C","Emp Name":"MANISHA JHA","Card No":"2076","Department":"THBS","Att Date":"06-Jun-2019","In Time":"06-Jun-2019 10:03","Out Time":"06-Jun-2019 19:46","Status":"P ","Late By ":"01:03","Early By ":"00:00","Total Hour":"09:43","OT Hour":"00:43","Location":"Consolidated","id":"A10088P2C-06-Jun-2019"},{"_id":ObjectId("5d7f2eefcb072306dd7e67a8"),"Emp No":"A10088P2C","Emp Name":"MANISHA JHA","Card No":"2076","Department":"THBS","Att Date":"07-Jun-2019","In Time":"07-Jun-2019 10:01","Out Time":"07-Jun-2019 18:19","Status":"P ","Late By ":"01:01","Early By ":"00:00","Total Hour":"08:18","OT Hour":"00:00","Location":"Consolidated","id":"A10088P2C-07-Jun-2019"},{"_id":ObjectId("5d7f2eefcb072306dd7e67a9"),"Emp No":"A10088P2C","Emp Name":"MANISHA JHA","Card No":"2076","Department":"THBS","Att Date":"10-Jun-2019","In Time":"10-Jun-2019 10:32","Out Time":"10-Jun-2019 18:25","Status":"O ","Late By ":"01:32","Early By ":"00:00","Total Hour":"07:53","OT Hour":"00:00","Location":"Consolidated","id":"A10088P2C-10-Jun-2019"},{"_id":ObjectId("5d7f2eefcb072306dd7e67aa"),"Emp No":"A10088P2C","Emp Name":"MANISHA JHA","Card No":"2076","Department":"THBS","Att Date":"11-Jun-2019","In Time":"11-Jun-2019 10:08","Out Time":"11-Jun-2019 18:25","Status":"P ","Late By ":"01:08","Early By ":"00:00","Total Hour":"08:17","OT Hour":"00:00","Location":"Consolidated","id":"A10088P2C-11-Jun-2019"},{"_id":ObjectId("5d7f2eefcb072306dd7e67ab"),"Emp No":"A10088P2C","Emp Name":"MANISHA JHA","Card No":"2076","Department":"THBS","Att Date":"12-Jun-2019","In Time":"12-Jun-2019 09:58","Out Time":"12-Jun-2019 18:26","Status":"P ","Late By ":"00:58","Early By ":"00:00","Total Hour":"08:28","OT Hour":"00:00","Location":"Consolidated","id":"A10088P2C-12-Jun-2019"},{"_id":ObjectId("5d7f2eefcb072306dd7e67ac"),"Emp No":"A10088P2C","Emp Name":"MANISHA JHA","Card No":"2076","Department":"THBS","Att Date":"13-Jun-2019","In Time":"13-Jun-2019 09:57","Out Time":"13-Jun-2019 14:28","Status":"P ","Late By ":"00:57","Early By ":"03:32","Total Hour":"04:31","OT Hour":"00:00","Location":"Consolidated","id":"A10088P2C-13-Jun-2019"},{"_id":ObjectId("5d7f2eefcb072306dd7e67ad"),"Emp No":"A10088P2C","Emp Name":"MANISHA JHA","Card No":"2076","Department":"THBS","Att Date":"14-Jun-2019","In Time":"14-Jun-2019 10:04","Out Time":"14-Jun-2019 18:13","Status":"P ","Late By ":"01:04","Early By ":"00:00","Total Hour":"08:09","OT Hour":"00:00","Location":"Consolidated","id":"A10088P2C-14-Jun-2019"},{"_id":ObjectId("5d7f2eefcb072306dd7e67ae"),"Emp No":"A10088P2C","Emp Name":"MANISHA JHA","Card No":"2076","Department":"THBS","Att Date":"17-Jun-2019","In Time":"17-Jun-2019 13:16","Out Time":"17-Jun-2019 18:25","Status":"P ","Late By ":"04:16","Early By ":"00:00","Total Hour":"05:09","OT Hour":"00:00","Location":"Consolidated","id":"A10088P2C-17-Jun-2019"},{"_id":ObjectId("5d7f2eefcb072306dd7e67af"),"Emp No":"A10088P2C","Emp Name":"MANISHA JHA","Card No":"2076","Department":"THBS","Att Date":"18-Jun-2019","In Time":"18-Jun-2019 09:39","Out Time":"18-Jun-2019 18:27","Status":"P ","Late By ":"00:39","Early By ":"00:00","Total Hour":"08:48","OT Hour":"00:00","Location":"Consolidated","id":"A10088P2C-18-Jun-2019"},{"_id":ObjectId("5d7f2eefcb072306dd7e67b0"),"Emp No":"A10088P2C","Emp Name":"MANISHA JHA","Card No":"2076","Department":"THBS","Att Date":"19-Jun-2019","In Time":"19-Jun-2019 09:48","Out Time":"19-Jun-2019 18:12","Status":"P ","Late By ":"00:48","Early By ":"00:00","Total Hour":"08:24","OT Hour":"00:00","Location":"Consolidated","id":"A10088P2C-19-Jun-2019"},{"_id":ObjectId("5d7f2eefcb072306dd7e67b1"),"Emp No":"A10088P2C","Emp Name":"MANISHA JHA","Card No":"2076","Department":"THBS","Att Date":"21-Jun-2019","In Time":"21-Jun-2019 11:02","Out Time":"21-Jun-2019 18:15","Status":"P ","Late By ":"02:02","Early By ":"00:00","Total Hour":"07:13","OT Hour":"00:00","Location":"Consolidated","id":"A10088P2C-21-Jun-2019"},{"_id":ObjectId("5d7f2eefcb072306dd7e67b2"),"Emp No":"A10088P2C","Emp Name":"MANISHA JHA","Card No":"2076","Department":"THBS","Att Date":"24-Jun-2019","In Time":"24-Jun-2019 10:05","Out Time":"24-Jun-2019 20:25","Status":"P ","Late By ":"01:05","Early By ":"00:00","Total Hour":"10:20","OT Hour":"01:20","Location":"Consolidated","id":"A10088P2C-24-Jun-2019"},{"_id":ObjectId("5d7f2eefcb072306dd7e67b3"),"Emp No":"A10088P2C","Emp Name":"MANISHA JHA","Card No":"2076","Department":"THBS","Att Date":"25-Jun-2019","In Time":"25-Jun-2019 19:09","Out Time":"25-Jun-2019 21:03","Status":"P ","Late By ":"10:09","Early By ":"00:00","Total Hour":"01:54","OT Hour":"00:00","Location":"Consolidated","id":"A10088P2C-25-Jun-2019"},{"_id":ObjectId("5d7f2eefcb072306dd7e67b4"),"Emp No":"A10088P2C","Emp Name":"MANISHA JHA","Card No":"2076","Department":"THBS","Att Date":"27-Jun-2019","In Time":"27-Jun-2019 09:41","Out Time":"27-Jun-2019 18:32","Status":"P ","Late By ":"00:41","Early By ":"00:00","Total Hour":"08:51","OT Hour":"00:00","Location":"Consolidated","id":"A10088P2C-27-Jun-2019"},{"_id":ObjectId("5d7f2eefcb072306dd7e67b5"),"Emp No":"A10088P2C","Emp Name":"MANISHA JHA","Card No":"2076","Department":"THBS","Att Date":"28-Jun-2019","In Time":"28-Jun-2019 10:17","Out Time":"28-Jun-2019 18:08","Status":"P ","Late By ":"01:17","Early By ":"00:00","Total Hour":"07:51","OT Hour":"00:00","Location":"Consolidated","id":"A10088P2C-28-Jun-2019"},{"_id":ObjectId("5d7f2eefcb072306dd7e67b6"),"Emp No":"A1016OBW","Emp Name":"DEEPAK DAHIYA","Card No":"24700","Department":"HUAWEI","Att Date":"04-Jun-2019","In Time":"04-Jun-2019 11:39","Out Time":"MANISHA JAH","Status":"P ","Late By ":"02:39","Early By ":"00:24","Total Hour":"05:57","OT Hour":"00:00","Location":"Consolidated","id":"A1016OBW-04-Jun-2019"},{"_id":ObjectId("5d7f2eefcb072306dd7e67b7"),"Emp No":"A1016OBW","Emp Name":"DEEPAK DAHIYA","Card No":"24700","Department":"HUAWEI","Att Date":"05-Jun-2019","In Time":"05-Jun-2019 11:09","Out Time":"05-Jun-2019 17:36","Status":"P ","Late By ":"02:09","Early By ":"00:24","Total Hour":"06:27","OT Hour":"00:00","Location":"Consolidated","id":"A1016OBW-05-Jun-2019"},{"_id":ObjectId("5d7f2eefcb072306dd7e67b8"),"Emp No":"A1016OBW","Emp Name":"DEEPAK DAHIYA","Card No":"24700","Department":"HUAWEI","Att Date":"06-Jun-2019","In Time":"06-Jun-2019 11:10","Out Time":"06-Jun-2019 16:42","Status":"O ","Late By ":"02:10","Early By ":"01:18","Total Hour":"05:32","OT Hour":"00:00","Location":"Consolidated","id":"A1016OBW-06-Jun-2019"}]

db.collection.aggregate({$group:{_id:"$Department",totalAttendance:{$sum:"$Status"},}})