[{"_id":ObjectId("5f90ed2954d61feed1720603"),"date":ISODate("2020-10-22T00:00:00Z"),"worker_full_name":"JOHN DOE","worker_department":"Worker Department","type":"Worker","site_name":"DL LIMITED","in_time":ISODate("2020-10-22T07:53:35Z"),"attendance_points":2,"out_time":ISODate("2020-10-22T22:03:41Z"),"duration":14,"attendance_count":2,"wage":580,"in_location":"Countryside Avenue","worker_aadhar_card_number":"xxxxxxxxxxxx","out_location":"Golf Drive","worker_id":ObjectId("5f12ea794fdb64e82ce68fac")},{"_id":ObjectId("5f90ed2754d61feed17205fe"),"date":ISODate("2020-10-22T00:00:00Z"),"worker_full_name":"JOHN DOE 2","worker_department":"Worker Department","type":"Worker","site_name":"DL LIMITED","in_time":ISODate("2020-10-22T07:53:34Z"),"attendance_points":2,"out_time":ISODate("2020-10-22T22:24:02Z"),"duration":14,"attendance_count":2,"wage":0,"in_location":"Countryside Avenue","worker_aadhar_card_number":"xxxxxxxxxxxx","out_location":"Countryside Avenue","worker_id":ObjectId("5f688cf2df29927bfb8531eb")}]

db.collection.aggregate([{"$match":{"date":{"$gte":ISODate("2020-10-21T00:00:00Z"),"$lte":ISODate("2020-10-23T00:00:00Z")},"worker_full_name":{"$exists":"true"},"site_name":"DL LIMITED"}},{"$group":{"_id":{"worker_id":"$worker_id","worker_full_name":"$worker_full_name"},daily_points_stats:{$push:{date:"$date",points:"$attendance_count"}},"present_days":{"$sum":1},"total_shift_points":{"$sum":"$attendance_points"}}}])