Database
[{"collection":"collection","count":100,"content":{"timestamp":{"type":"date","startDate":"2024-11-22T00:00:00+08:00","endDate":"2024-12-15T00:00:00+08:00"}}}]
Query
db.collection.aggregate([{$match:{timestamp:{$gte:ISODate("2024-12-01"),$lte:ISODate("2024-12-07")}}},{$group:{_id:{timestamp:{$dateTrunc:{date:"$timestamp",unit:"day",binSize:7}}},count:{$sum:1}}},{$set:{timestamp:"$_id.timestamp"}},{$sort:{timestamp:1}}])