How to create graph on Dashboard from multiple choice string

MiriamWebborn

Hi there, 

First time posting on here. I keep running into what seem like limitations with the software but I am determined that there must be a work around. 

I have several Survey123 surveys which have multiple choice questions. The outputs from these questions are in a string e.g., 'banana, orange, apple'.

What I would like to do is create a pie or bar chart in ArcGIS Dashboards to display the number of times each choice in the multiple choice was individually selected across all submissions e.g., banana = 34, orange =26, apple = 54. 

I have recently discovered New Data Expression section in Dashboards and feel this must be the way. 

Can someone confirm this is how it would be done? If so, I will provide the details of my survey and would really appreciate some help with the code. 

Thanks in advance. 

JA7

When you open the builder to create a data expression, there is link to several sample data expressions, including this one that handles the Survey123 multi-selects. It says it's for use in pie charts, but you can just use it in a serial chart just fine. 

SplitCategories(PieChart).md

You will need to make a few updates to work with your data.

1. If you are using ArcGIS Enterprise, use your enterprise URL

2. From top to bottom, survey data layer item id, survey data layer layer id, multi-select field name

3. Multi-select field name