[{_id:"B000000OE4","product/title":"Working Class Hero","product/price":"16.99",reviews:[{"review/userId":"unknown","review/profileName":"unknown","review/helpfulness":"2/3","review/score":"4.0","review/time":"27/05/1999/00:00:00","review/summary":"Worth it for one song","review/text":"I really like Joan Baez'..."},{"review/userId":"A1W0RKM6J6J73L","review/profileName":"Aaron Woodin (purchagent@aol.com)","review/helpfulness":"1/1","review/score":"3.0","review/time":"09/02/1999/00:00:00","review/summary":"The critical lambasting on the Amazon Page Missed one thing.","review/text":"They forgot to mention Mary Chapin..."},{"review/userId":"A1W0RKM6J6J73A","review/profileName":"Aaron Woodin (purchagent@aol.com)","review/helpfulness":"1/1","review/score":"4.0","review/time":"09/02/1999/00:00:00","review/summary":"The critical lambasting on the Amazon Page Missed one thing.","review/text":"They forgot to mention Mary Chapin..."},{"review/userId":"A1W0RKM6J6J73B","review/profileName":"Aaron Woodin (purchagent@aol.com)","review/helpfulness":"1/1","review/score":"1.0","review/time":"09/02/1999/00:00:00","review/summary":"The critical lambasting on the Amazon Page Missed one thing.","review/text":"They forgot to mention Mary Chapin..."},]}]

db.collection.update({},[{$set:{reviewsData:{$map:{input:"$reviews.review/score",in:{$toDouble:"$$this"}}}}},{$set:{reviewScoreDistrib:{$arrayToObject:{$map:{input:{$range:[1,6]},as:"num",in:{k:{$toString:"$$num"},v:{$size:{$filter:{input:"$reviewsData",cond:{$eq:["$$this","$$num"]}}}}}}}},avgReviewScore:{$avg:"$reviewsData"},reviewsCount:{$size:"$reviewsData"}}}])