Count a selected answer from a list_name in Survey123?

604
1
03-10-2020 02:58 PM
DevonJones
New Contributor

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

0 Kudos
1 Reply
JamesTedrick
Esri Esteemed Contributor

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.

0 Kudos