[{"_id":"633360536b4cab132e2fc277","username":"Alberto Silva","role":"player","questionList":[{"questionid":"A0","time":null,"answered":null,"score":null,"status":"not-attempted","startDate":null,"respondedDate":null},{"questionid":"A1","time":null,"answered":null,"score":null,"status":"not-attempted","startDate":null,"respondedDate":null},{"questionid":"A2","time":null,"answered":null,"score":null,"status":"not-attempted","startDate":null,"respondedDate":null},],"team":"3"},{"_id":"633360536b4cab132e2fc218","username":"Joana Oliveira","role":"player","questionList":[{"questionid":"A0","time":null,"answered":null,"score":null,"status":"not-attempted","startDate":null,"respondedDate":null},{"questionid":"A1","time":null,"answered":null,"score":null,"status":"not-attempted","startDate":null,"respondedDate":null},{"questionid":"A2","time":null,"answered":null,"score":null,"status":"not-attempted","startDate":null,"respondedDate":null},],"team":"0"},{"_id":"633360536b4cab132e2fc215","username":"Renato Silvestre","role":"player","questionList":[{"questionid":"A0","time":null,"answered":null,"score":null,"status":"not-attempted","startDate":null,"respondedDate":null},{"questionid":"A1","time":null,"answered":null,"score":null,"status":"not-attempted","startDate":null,"respondedDate":null},{"questionid":"A2","time":null,"answered":null,"score":null,"status":"failed","startDate":null,"respondedDate":null},],"team":"0"},]

db.collection.aggregate([{"$addFields":{"availableQuestions":"$questionList"}},{$unwind:"$availableQuestions"},{$group:{_id:"$_id",name:{$first:"$username"},availableQuestions:{$push:{$cond:{if:{$eq:["$availableQuestions.status","not-attempted"]},then:"$availableQuestions.questionid",else:"$$REMOVE"},}},availableCount:{$sum:{$cond:{if:{$eq:["$questionList.status","not-attempted"]},then:1,else:"$$REMOVE"}}},},},{$group:{_id:"$_id",name:{$first:"$name"},questionList:{$push:{questionid:{$arrayElemAt:["$availableQuestions",{$round:{$multiply:[{$rand:{}},{$subtract:[{$add:"$availableCount"},1]}]}}]},status:"assigned"}}}}])