I need a report that shows the number of questions in an quiz

Maureen.B.923

Hey folks,

I just need a report that shows all the quizzes in our system, and how many questions are in them. (e.g. Quiz A has 20 questions. Quiz B has 125 questions. Quiz C has 35 questions.) I'm pulling a blank on how to do this. 😒

Jennifer.W.973

I had set up a flow for finding all questions and answer choices in an OrgUnit: https://github.com/jenniferwagner18/brightspace-etl-dataflows/blob/main/quiz-questions-answers.md You can ignore the survey sections if you don't have sections or pools and the answers data sets if you don't need the answer choices. Then you can just do a Group By and count the number of QuestionIds per quiz.

EDIT: Here's what I did to count the quiz questions in one OrgUnit (my university has way too much data for me to try this for the entire org). I had to remove duplicates due to edited questions and filter out deleted questions before doing the group by. The output is just two columns: the name of the quiz and the total number of questions.