Analysing Select_Multiple Answers

Question

Hi All,

I want to start a discussion on how we should actually analyse the data that we have collected from Survey 123 and produce graphically meaningful results from the data.

Select_Multiple answers gets stored as a comma separated answer in a single field when the data is pushed to AGOL as a feature layer.

How do we create statistics for select_multiple answers with current AGOL tools to parse the comma separated values? We can do this from the online Survey 123 dashboard under Analyze but I would ideally want the statistic to be reproduced in AGOL as well.

Thanks,

Weng

Hannekevan_Dis · Answer

Hi @AnnaScholl, Besides seeing the results through the "Analyze" tab of your survey in survey123.arcgis.com/surveys it is also possible to get results through a Dashboard. See example 1 in the following blog: https://www.esri.com/arcgis-blog/products/ops-dashboard/announcements/introducing-data-expressions-in-arcgis-dashboards/

AnnaScholl · Answer

Hi @WengNg... You said a long time ago... "We can do this from the online Survey 123 dashboard under Analyze"
How can I do this? I unfortunately have a lot of multiple select questions.

cnnlly · Answer

For customer projects I'm working on, we're looking at post processing the data as well - similar to Weng, seperate the values based on commas and then replace _ with spaces.

Another question would be, how are people handling 'or_other' or 'Other' relevant fields?

I've found with Survey123 that it's awesome you can make a complex survey really easy to use for the end user but then as the data administrator your life is made more complicated!

Carmel