[{"_id":ObjectId("5d7f2eefcb072306dd7e67a5"),"Emp No":"A10088P2C","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("5e7f2eefcb072306dd7e67a5"),"Emp No":"A20088P2C","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":"A20088P2C-03-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:{dept:"$Department",emp:"$Emp No"},total:{"$sum":1}}},{$group:{_id:"$_id.dept",total:{"$sum":1}}}])