Database
[{"_id":1,"review_id":"1","product_id":"1","date":ISODate("2021-11-12T21:00:00.000Z"),"rating":5,"title":"lorem","review":"lorem","updated_at":ISODate("2021-12-07T07:10:55.732Z"),"created_at":ISODate("2021-12-07T05:04:11.750Z")},{"_id":2,"review_id":"1","product_id":"1","date":ISODate("2021-11-12T21:00:00.000Z"),"rating":3,"title":"lorem","review":"lorem","updated_at":ISODate("2021-12-07T07:10:55.732Z"),"created_at":ISODate("2021-12-07T05:04:11.750Z")},{"_id":3,"review_id":"1","product_id":"1","date":ISODate("2021-11-12T21:00:00.000Z"),"rating":3,"title":"lorem","review":"lorem","updated_at":ISODate("2021-12-07T07:10:55.732Z"),"created_at":ISODate("2021-12-07T05:04:11.750Z")}]
Query
db.collection.aggregate({"$group":{"_id":{"month":{"$month":{"$toDate":"$date"}},"year":{"$year":{"$toDate":"$date"}},"rating":"$rating"},"reviews":{"$sum":1}}})