Using Survey123 select_multiple questions in Ops Dashboard?

580
4
Jump to solution
05-22-2019 07:00 AM
Highlighted
Occasional Contributor II

I'm looking for any suggestions or solutions to using a Survey123 select_multiple response within Operations Dashboard.  This question type outputs as a comma delimited field which makes it pretty much unusable in Ops Dashboard.  

I went through the steps of pulling out the unique answers into hidden fields as yes/no... through the calculation column:  if(selected(${name},'somevalue'), 'Yes', 'No')  ...but still can't find a good solution to displaying/summarizing this info in any of the Dashboard elements.

What I would like to be able to do to count the number of times a value (not a response) has been selected for each question and also graph those with the other.  This works well in the survey123.arcgis.com website, but Ops Dashboard is completely different...

Thanks!

1 Solution

Accepted Solutions
Highlighted
Esri Contributor

Hi Danielle,

Hi Eric,

 

This issue has been raised to technical support before, and this is the public explanation:

 

"Selections made for a select_multiple question are stored as a comma-separated string. This is a known limitation of select_multiple questions.

 

In order to query the selections individually, each selection can be separated out to its own question. This can be achieved using if() statements with the selected(question, value) function. These additional questions can be hidden if necessary.

 

This technique is described in the following GeoNet blog (refer to the "Controlling how user selections are stored in ArcGIS" section):

https://community.esri.com/groups/survey123/blog/2017/08/30/understanding-multiple-choice-questions-...

 

Additional information on these functions is available in this blog post:

https://community.esri.com/groups/survey123/blog/2018/12/02/survey123-tricks-of-the-trade-xlsform-fu...

 

 

I hope this is helpful on the Survey123 form side of things. Additionally, there is a new enhancement logged for a change in Operations Dashboard: ENH-000129890 - "Allow for the indicator widget in ArcGIS Dashboard to parse through a string field that was created by a 'select_multiple answers' question in Survey 123, so that the widget accurately counts the number of times each answer occurs." While it has not yet been decided whether or not this enhancement will be implemented, you can always call in to Technical Support and ask that it be attached to your account.

 

Thank you,

Gillian

View solution in original post

4 Replies
Highlighted
Frequent Contributor II

This is what I do in the form.

Have a calc field that counts only non 0 answers answers if(${HeightHerbaceous}>0,1,0)

Then I have a second field to do an avg using Sum.  sum(${HeightHerbaceous}) div sum(${nonzeroherbhgt})

You can also use things like count() to see how many total.

You could do this then you will have a field in your form that already has the Avg for you.  Then you can use this field directly in Ops Dashboard.

In your example of 

if(selected(${name},'somevalue'), 'Yes', 'No')

Change to 

if(selected(${name},'somevalue'), 1, 0)

Of course if someone edits the data directly later the calcs will be wrong.

Highlighted
Occasional Contributor II

Thanks Doug! 

I'm not sure this will do what I need, but will keep this in mind for next time and give it a try...

After I added the if(selected(${name},'somevalue'), 'Yes', 'No') calculation, I wasn't able to republish my survey, presumably because that would have created too many fields.  I'm not sure what the field limit is, but I'm pretty sure I hit hit.  I removed these (actually just made them "null" under the field type column so they wouldn't write), and was able to republish the survey.  They were functioning fine before trying to republish, so I'm pretty certain there wasn't an error in the equation.

In regards to your suggestion, if I'm thinking through this correctly, I could use the Indicator element for a single "somevalue", but not the Serial Chart to graph all answers from a single question. Do you know if it's possible to force multiple attributes into the Serial Chart in order to build a graph from the specific fields I need (instead of it being built from a single attribute)?  Not sure if that makes sense.

Danielle

Reply
0 Kudos
Highlighted
Frequent Contributor II

So you mean you want to point to a string field and have it pie chart the options right?  I have never found a way to do this.  Seems simple enough but Arc seems to assume no strings, which is weird really - seems like the best use of this.

Reply
0 Kudos
Highlighted
Esri Contributor

Hi Danielle,

Hi Eric,

 

This issue has been raised to technical support before, and this is the public explanation:

 

"Selections made for a select_multiple question are stored as a comma-separated string. This is a known limitation of select_multiple questions.

 

In order to query the selections individually, each selection can be separated out to its own question. This can be achieved using if() statements with the selected(question, value) function. These additional questions can be hidden if necessary.

 

This technique is described in the following GeoNet blog (refer to the "Controlling how user selections are stored in ArcGIS" section):

https://community.esri.com/groups/survey123/blog/2017/08/30/understanding-multiple-choice-questions-...

 

Additional information on these functions is available in this blog post:

https://community.esri.com/groups/survey123/blog/2018/12/02/survey123-tricks-of-the-trade-xlsform-fu...

 

 

I hope this is helpful on the Survey123 form side of things. Additionally, there is a new enhancement logged for a change in Operations Dashboard: ENH-000129890 - "Allow for the indicator widget in ArcGIS Dashboard to parse through a string field that was created by a 'select_multiple answers' question in Survey 123, so that the widget accurately counts the number of times each answer occurs." While it has not yet been decided whether or not this enhancement will be implemented, you can always call in to Technical Support and ask that it be attached to your account.

 

Thank you,

Gillian

View solution in original post