Database
[{"name":"Medical Visit Survey","question":["Ease of making an appointment?","About how long was your wait time before being seen by the provider?","Professionalism of person who took your call?"],"type":["radiobutton","radiobutton","radiobutton"],"answers":["Excellent","Less than 20 minutes","Excellent"]},{"name":"Medical Visit Survey","question":["Ease of making an appointment?","About how long was your wait time before being seen by the provider?","Professionalism of person who took your call?"],"type":["radiobutton","radiobutton","radiobutton"],"answers":["Excellent","Less than 20 minutes","Very Good"]}]
Query
db.collection.aggregate([{$unwind:"$answers"},{$group:{_id:"$answers",count:{$sum:1}}}])