nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Survey Results in Operations Dashboard?

AprilChipman

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.

Najděte více příspěvků označených jako

Accepted answers

All comments

Zelong

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

MichelleWilliams1

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.

Anonymous User

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.

NickDierks1

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.

AprilChipman

Yes, it is a Select Multiple question.

So do you think I'm out of luck?

NickDierks1

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.

AprilChipman

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!

ClaytonCooley1

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.

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.