Is there a way to count the times an answer is selected throughout the Survey123 form from a given list_name?
I'm creating a form with hundreds of different questions using the same list_name in the type column. If the list_name is "score" and the choices are 1, 2, or 3, I would like to have a simple calculation that will count all the times throughout the form that select_one score was used and returned 1 as an answer.
The only way I know to do this is to calculate using the field name, but with hundreds of questions, I can't wrap my head around writing that formula. Please help!
Devon
Hi Devon,
There isn't a function that inspects all the choices selected across different questions. You can use the selected() function to evaluate each question. This may be an activity that is better done after submittal using Python or Arcade to iterate through the fields.