db={"Collection":[{"_createdAt":ISODate("2021-04-30T23:59:00.000Z"),"ApiRequestType":"InstrumentDetails","RequesterSystem":"Generic_Reporting","ResponseMessage":"bleep bop boop beep"},{"_createdAt":ISODate("2021-05-01T00:01:00.000Z"),"ApiRequestType":"InstrumentDetails","RequesterSystem":"Generic_Reporting","ResponseMessage":"bleep bop boop beep"},{"_createdAt":ISODate("2021-05-01T00:11:00.000Z"),"ApiRequestType":"GastroDetails","RequesterSystem":"Generic_Reporting","AudioMessage":"burp"},{"_createdAt":ISODate("2021-05-01T20:01:00.000Z"),"ApiRequestType":"InstrumentDetails","RequesterSystem":"Generic_Reporting","PowerMessage":"Fully Charged"},{"_createdAt":ISODate("2021-05-01T23:59:00.000Z"),"ApiRequestType":"InstrumentDetails","RequesterSystem":"Generic_Reporting","ResponseMessage":"bleep bop boop beep"},{"_createdAt":ISODate("2021-05-02T00:01:00.000Z"),"ApiRequestType":"InstrumentDetails","RequesterSystem":"Generic_Reporting","ResponseMessage":"bleep bop boop beep"},{"_createdAt":ISODate("2021-05-03T00:00:00.000Z"),"ApiRequestType":"InstrumentDetails","RequesterSystem":"Generic_Reporting","WarrantyMessage":"28 Days until Expiration"}]}

db.Collection.aggregate([{$match:{$and:[{"_createdAt":{$gte:ISODate("2021-05-01T00:00:00.000Z")}},{"_createdAt":{$lt:ISODate("2022-02-02T00:00:00.000Z")}},{"ApiRequestType":"InstrumentDetails"},{"RequesterSystem":"Generic_Reporting"}]}},{$group:{_id:{day:{$dayOfMonth:"$_createdAt"},month:{$month:"$_createdAt"},year:{$year:"$_createdAt"}},count:{$sum:1},date:{$first:"$_createdAt"},"ResponseMessage":{"$push":"$ResponseMessage"}}},{$project:{date:{$dateToString:{format:"%Y-%m-%d",date:"$date"}},count:1,_id:1,numberOfRMCount:{$size:"$ResponseMessage"}}}])