[{"_id":ObjectId("62ae5b41ab17b7cbb04dc370"),"orderId":123,"createdAt":ISODate("2022-06-18T23:12:00.037+00:00")},{"_id":ObjectId("62ae5b41ab17b7cbb04dc371"),"orderId":456,"createdAt":ISODate("2022-06-18T23:11:00.037+00:00")},{"_id":ObjectId("62ae5babab17b7cbb04dc372"),"createdAt":ISODate("2022-06-18T23:07:00.037+00:00")},{"_id":ObjectId("62ae5babab17b7cbb04dc373"),"createdAt":ISODate("2022-06-18T23:04:00.037+00:00")},{"_id":ObjectId("62ae5babab17b7cbb04dc374"),"orderId":7890,"createdAt":ISODate("2022-06-18T23:04:00.037+00:00")}]

db.collection.aggregate([{$match:{createdAt:{/** start of day*/$gte:ISODate("2022-06-18T00:00:00.000Z"),/** end of day*/$lt:ISODate("2022-06-18T23:59:59.999Z")}}},{$addFields:{status:{$cond:["$orderId","completed","abandoned"]}}},{$group:{_id:"$status",count:{$sum:1}}}])