topic Survey Results in Operations Dashboard? in ArcGIS Survey123 Questions

Survey Results in Operations Dashboard?

AprilChipman — Fri, 05 Apr 2019 18:46:03 GMT

I've created a Survey123 questionnaire, but I would like to show the results in an Operations Dashboard. Some of my questions are multiple choice and I would like to show the number of times a user selects each choice. Basically, I want to show in Ops Dashboard a graph just like the one that Survey123 automatically generates. I can't seem to figure it out, though!

Here is what Survey123 looks like:

and here is what my Ops Dashboard looks like:

I feel like I've tried everything, but I just can't seem to get those values to ungroup in the graph! I want to know how many people choose each day of the week, not how many options there are with seven choices.

Re: Survey Results in Operations Dashboard?

ClaytonCooley1 — Fri, 05 Apr 2019 19:05:58 GMT

I just tried this with my own Survey123 data and it seemed pretty straightforward. First, be sure you're pulling data from the correct layer. Survey123 creates three layers: '_Stakeholder', '_Fieldworker', and the main data layer (this does not have a descriptive name). You'll need to select the main layer, then the 'surveyPoint' feature. Once you select your layer, select 'Grouped Values' next to Categories From. Then, just select the field you want to see and it should pop up in the window to the right. Be sure that you have 'Count' selected under Statistics. You can then change the colors by value by going to the Series tab to the left.

Re: Survey Results in Operations Dashboard?

AprilChipman — Fri, 05 Apr 2019 19:21:41 GMT

Thanks for the response, Clayton! Unfortunately, this is how I have my dashboard setup and I'm not getting similar results. There's got to be something else going on here!

Re: Survey Results in Operations Dashboard?

NickDierks1 — Fri, 05 Apr 2019 19:41:35 GMT

Is that question a select_multiple? If so, I don't think Operations Dashboard is able to parse out the individual choices within each survey response.

Re: Survey Results in Operations Dashboard?

AprilChipman — Fri, 05 Apr 2019 19:46:19 GMT

Yes, it is a Select Multiple question.

So do you think I'm out of luck?

Re: Survey Results in Operations Dashboard?

NickDierks1 — Fri, 05 Apr 2019 20:45:31 GMT

Unless someone else knows of a workaround, I think you might be. There are currently some enhancement requests for supporting Arcade expressions in Operations Dashboard, which might be able to get the job done depending on how that's implemented, but that's still not a reality yet.

Otherwise, reworking your survey to avoid using a select_multiple, or adding a bunch of hidden fields (monday_yesno, tuesday_yesno, etc.) may be your only options for recreating that graph in Ops Dashboard.

Re: Survey Results in Operations Dashboard?

Anonymous User — Wed, 04 Dec 2019 23:15:03 GMT

To expand on what Nick Dierks‌ stated, the current workaround is to utilize hidden fields.

For example:

type

name

label

calculation

esri::bind:fieldType

select_multiple picklist

picklist

Pick a value

hidden

value1

Value 1

if(selected(${picklist}, 'value1'), 1, 0)

esriFieldTypeInteger

Casting as an Integer here is important otherwise the form will publish the value as a string and will be inaccessible as an options in the Fields category. Then in Ops Dashboard, add a Serial Chart and select Categories From: Fields in Data Options. Now for each Category, add the hidden field and ensure you use the Sum statistic to get a count of each hidden field.

You'll end up with something like this

Let me know if you need any additional clarification.

Re: Survey Results in Operations Dashboard?

MichelleWilliams1 — Sat, 07 Dec 2019 00:18:31 GMT

This will probably work for me too. I have a select multiple with Job Types, and I needed a way to show them individually. Thank you.

Re: Survey Results in Operations Dashboard?

Zelong — Tue, 14 Oct 2025 18:12:39 GMT

I am facing a similar situation, per this solution I would have to adjust the survey123 form?