Database

[{"_id":ObjectId("64c8de6e10f1e5f6958033d7"),"address":"nowhere","city":"NY","name":"ABD","count":NumberInt(19),"timestamp":ISODate("2023-08-01T05:30:42.956Z")},{"_id":ObjectId("64c8de6e10f1e5f6958033d6"),"address":"somewhere","city":"NY","name":"WBE","count":NumberInt(4),"timestamp":ISODate("2023-08-01T05:29:02.956Z")},{"_id":ObjectId("64c8de6e10f1e5f6958033da"),"address":"somewhere","city":"NY","name":"WBE","count":NumberInt(18),"timestamp":ISODate("2023-08-01T08:30:42.956Z")}]

Query

db.collection.aggregate([{"$facet":{"last12Hours":[{$match:{timestamp:{$gte:ISODate("2023-08-01T15:36:38.059Z")}}},{$group:{_id:"$name",count:{$sum:"$count"},city:{$first:"$city"}},},{$sort:{count:-1}},{$limit:5},{$project:{_id:0,name:"$_id",city:"$city",count:1,}}],"last24Hours":[{$match:{timestamp:{$gte:ISODate("2023-08-01T03:36:38.059Z")}}},{$group:{_id:"$name",count:{$sum:"$count"},city:{$first:"$city"}},},{$sort:{count:-1}},{$limit:5},{$project:{_id:0,name:"$_id",city:"$city",count:1,}}]}}])

Result