Database
[{"_id":ObjectId("6218b5f0405919280c209f73"),"inspectionResult":"Passed","projectId":ObjectId("6227089af6d4162e9c57d8be"),"accountId":ObjectId("621888e852bd8836c04b8f82"),"dateInspected":ISODate("2022-03-08T00:00:00.000Z"),}]
Query
db.collection.aggregate([{$match:{accountId:ObjectId("621888e852bd8836c04b8f82"),projectId:ObjectId("6227089af6d4162e9c57d8be"),}},{$group:{_id:null,dateInsp:{$first:"$inspectionResult"},Y:{$sum:1}}},{$project:{_id:0,x:"PWI",Y:1,dateInsp:1}}])