[{_id:1,name:"Abraham",class:"V",question_answered:[{id:"quest1",answer:"A",score:10,question:{soal:"apa judul lagu?",correct_answer:"A",type_question:"Essay"}},{id:"quest2",answer:"C",score:null,question:{soal:"apa judul lagu B?",correct_answer:"B",type_question:"Essay"}},{id:"quest3",answer:"C",score:10,question:{soal:"apa judul lagu C?",correct_answer:"C",type_question:"essay_pg"}},]},{_id:2,name:"Brenda",class:"V",question_answered:[{id:"quest1",answer:"A",score:10,question:{soal:"apa judul lagu A?",correct_answer:"A",type_question:"Essay"}},{id:"quest2",answer:"C",score:0,question:{soal:"apa judul lagu B?",correct_answer:"B",type_question:"Essay"}}]}]

db.collection.aggregate([{"$addFields":{"formated_status_evaluation_essay":{"$filter":{"input":"$question_answered","as":"q","cond":{$eq:["$$q.question.type_question","Essay"]}}},"formated_status_evaluation_essay_pg":{"$filter":{"input":"$question_answered","as":"q","cond":{$eq:["$$q.question.type_question","essay_pg"]}}}}},{"$addFields":{"formated_status_evaluation_essay":{"$switch":{"branches":[{"case":{$and:[{"$allElementsTrue":[{"$map":{"input":"$formated_status_evaluation_essay.score","as":"s","in":{$ne:["$$s",null]}}}]},{$ne:[{$size:"$formated_status_evaluation_essay"},0]}]},"then":"complete scoring"},{"case":{"$anyElementTrue":[{"$map":{"input":"$formated_status_evaluation_essay.score","as":"s","in":{$eq:["$$s",null]}}}]},"then":"incomplete scoring"}],default:"no question"}},"formated_status_evaluation_essay_pg":{"$switch":{"branches":[{"case":{$and:[{"$allElementsTrue":[{"$map":{"input":"$formated_status_evaluation_essay_pg.score","as":"s","in":{$ne:["$$s",null]}}}]},{$ne:[{$size:"$formated_status_evaluation_essay_pg"},0]}]},"then":"complete scoring"},{"case":{"$anyElementTrue":[{"$map":{"input":"$formated_status_evaluation_essay_pg.score","as":"s","in":{$eq:["$$s",null]}}}]},"then":"incomplete scoring"}],default:"no question"}}}}])