Database
[{"title":"cartoons","views":1,"created_at":"2022-10-03 12:00:00.000Z"},{"title":"songs","views":4,"created_at":"2022-10-04 12:00:00.000Z"},{"title":"lectures","views":3,"created_at":"2022-10-10 12:00:00.000Z"},{"title":"news","views":2,"created_at":"2022-10-05 12:00:00.000Z"},{"title":"movies","views":6,"created_at":"2022-10-07 12:00:00.000Z"},{"title":"tv series","views":6,"created_at":"2022-10-12 12:00:00.000Z"}]
Query
db.collection.aggregate([{$addFields:{days:{$dayOfWeek:{$toDate:"$created_at"}}}},{$group:{_id:{days:"$days"},totalReview:{$sum:"$views"},daysCount:{$sum:1}}},{$project:{_id:0,totalReview:1,day:{$switch:{branches:[{"case":{$eq:["$_id.days",1]},then:"sunday"},{"case":{$eq:["$_id.days",2]},then:"monday"},{"case":{$eq:["$_id.days",3]},then:"tuesday"},{"case":{$eq:["$_id.days",4]},then:"wednesday"},{"case":{$eq:["$_id.days",5]},then:"thursday"},{"case":{$eq:["$_id.days",6]},then:"friday"},{"case":{$eq:["$_id.days",7]},then:"saturday"}],"default":"day unknown"}}}}])