Database

[{"_id":"1","ticketId":100,"createdAt":ISODate("2021-11-08T08:34:39.697Z")},{"_id":"2","ticketId":101,"createdAt":ISODate("2021-11-07T08:34:39.697Z")},{"_id":"3","ticketId":102,"createdAt":ISODate("2021-11-06T08:34:39.697Z")},{"_id":"4","ticketId":103,"createdAt":ISODate("2021-11-05T08:34:39.697Z")},{"_id":"5","ticketId":104,"createdAt":ISODate("2021-11-04T08:34:39.697Z")},{"_id":"6","ticketId":105,"createdAt":ISODate("2021-11-03T08:34:39.697Z")},{"_id":"7","ticketId":106,"createdAt":ISODate("2021-11-02T08:34:39.697Z")},{"_id":"8","ticketId":107,"createdAt":ISODate("2021-11-01T08:34:39.697Z")}]

Query

db.collection.aggregate([{"$facet":{"year":[{"$group":{"_id":{"year":{"$year":"$createdAt"}},"count":{"$sum":1}}},{"$project":{"_id":0,"year":"$_id.year","count":1}}],"month":[{"$group":{"_id":{"year":{"$year":"$createdAt"},"month":{"$month":"$createdAt"}},"count":{"$sum":1}}},{"$project":{"_id":0,"year":"$_id.year","month":"$_id.month","count":1}}],"week":[{"$group":{"_id":{"year":{"$year":"$createdAt"},"week":{"$week":"$createdAt"}},"count":{"$sum":1}}},{"$project":{"_id":0,"year":"$_id.year","week":"$_id.week","count":1}}],"day":[{"$group":{"_id":{"year":{"$year":"$createdAt"},"day":{"$dayOfYear":"$createdAt"}},"count":{"$sum":1}}},{"$project":{"_id":0,"year":"$_id.year","day":"$_id.day","count":1}}]}},{"$set":{"sums":{"$concatArrays":["$year","$month","$week","$day"]},"year":"$$REMOVE","month":"$$REMOVE","week":"$$REMOVE","day":"$$REMOVE"}},{"$unwind":{"path":"$sums"}},{"$replaceRoot":{"newRoot":"$sums"}},{"$match":{"$expr":{"$and":[{"$eq":["$year",{"$year":ISODate("2021-11-07T08:34:39.697Z")}]},{"$eq":["$week",{"$week":ISODate("2021-11-07T08:34:39.697Z")}]}]}}}])

Result