count values from a survey123 multi list

Question

I have added a 'select_multiple employee' list to my Survey123 Connect, in my Survey I will be selecting the names of the participants, it will vary from 1 - 20+.

1st, I would like to be able to tally how many participants I am selecting on my Dashboard. To see a running total of participants for various activities.

2nd, I would like to be able to have a vertical list of these individuals. right now the list shows Bob,Sally,Joe,Mike.... in a horizontal orientation with comma, makes it very difficult to read

I will eventually want to pull this data into a excel sheet, it would be nice to not have to jump through so many hoops to bring it into a vertical orientation.

nkittelson.pfmd · Answer

@ScottJones1 if your Org has a maintenance contract there are some online courses here: https://www.esri.com/training/catalog/search/

Otherwise, if you adapt one of the examples to your data and post back here, people can help out with troubleshooting.

Edit - another example: https://github.com/Esri/arcade-expressions/blob/master/dashboard/dashboard_data/SplitCategories(PieChart).md

ScottJones1 · Answer

Thanks Neal, It might be a minute but I will take a look, my other option is to utilize the Survey123 Analyze. Arcade is a new tool for me, do you know of any good reference guides? Arcade for Dummies?

nkittelson.pfmd · Answer

You should be able to write a Data Expression to split out you comma delimited list of names from a single row to a row per name.

Here are a couple posts that have Arcade examples to do that:

https://community.esri.com/t5/arcgis-dashboards-questions/creating-an-indicator-to-show-worker-attendance/m-p/1609473

https://community.esri.com/t5/arcgis-dashboards-questions/arcade-split-comma-delimited-value-into-multiple/m-p/1105537