Displaying the Results of an Audience Poll

[TomFlahive1]

I have a question on how to post results from a simple user poll to a Dashboard. We are thinking of using Survey123 to poll an audience to see what country they are from. It would be a very simple poll where the Survey123 form would have a single drop down box with a list of all the countries. Each audience member would select their country of origin and then submit. Once the poll is complete (or during the poll), we would like to display a map of the world in a Dashboard map and show a count of the number of people from each country. The count for each country would show as a label in the middle of that country.

This sounds like a simple task but we are having trouble figuring out an easy way to accomplish this. The survey would be linked to a non-spatial table. We would then need to add up the number of records for each country and then link those count results to the map of the world. The part we are having trouble with is taking the results of the survey (a count of individuals in each country) and getting them in a label on a Dashboard map.

If anyone has some suggestions on how this might be done, we would appreciate it.

[ABishop]

Hello Tom,

Where and what is the output of the results of the survey with the count?  

[TomFlahive1]

We did find a solution.  To answer your question Amanda, the results of the survey is just a non-spatial table with a text field that has the name of the country of origin.  There is one record for each participant who takes the survey.

The solution we came up with that allowed us to display the count of the number of participants from each country onto a map of the world was to use the Join Features analysis tool in ArcGIS Online. We had to use Map Viewer Classic to create the joined layer because currently the Join Features analysis tool is only available in map viewer classic.  We joined the survey table to the map of the world feature layer by using the country name text field.  We created the join as a one-to-one join. Then the key part is that we also added statistics to the Join (that's an option in the Join dialog box).  When you add a statistic summary field (we just picked a random field for that) in addition to adding that particular statistic field to the resulting join, the tool also adds a second field called join_count. That join_count field gave us the total participants for each country, which is what we were looking for, and we were able to label off of that field. One final thing to note is that we created the Join Features layer as a hosted feature layer view (the last checkbox in the Join dialog box). This created a hosted view layer that we were then able to bring into our Dashboard map for labeling purposes. It was a bit of a hack, but it works nicely.

[ABishop]

Sounds like it works well!  One thing I have noticed is when you publish views directly from the geodatabase their tends to be performance issues.  I am glad ESRI opened up a view option for hosted layers in the online environment.  Great job!