[{"_id":ObjectId("62a886a76034628f8028e8dc"),"create_time":"18:53:01","close_date":"2022-05-09","close_time":"13:34:43","country_code":"US","closed_case":1,"resolution_days":8,"status_code":"5","state_code":"1","issue_resolved_flag":"Yes","incident_created_by":"09D4A6BB-C51E-EB11-A813-000D3A58F938","incident_modified_by":"A3CBC776-DF3C-E711-810B-E0071B7284D1","modifiedon":"2022-05-09 13:34:46.0","row_insertion_dttm":"2022-06-14 02:58:21.202","data_source_category":"CASE","resolution_duration_minutes":1060,"create_date":"2022-05-01","repeat_case_different_issue7_day":0,"repeat_case_same_issue_7day":0,"scr_7day":1,"ocr_7day":0,"csat_status":"no"}]

db.collection.aggregate([{$group:{_id:{datebasis:"$create_date"},TotalRecordscount:{$sum:1},scr_7dayIsZero:{$sum:{$cond:{if:{$eq:["$scr_7day",0]},then:1,else:0}}},resolution_duration_minutesLessThan1440:{$sum:{$cond:{if:{$lt:["$resolution_duration_minutes",1440]},then:1,else:0}}}}}])