Counts and Amonuts (color) option not showing on AGOL Map

1308
8
03-03-2021 02:53 PM
JulietK
Occasional Contributor II

Hi, 

I am trying to create a choropleth map using a Survey123 generated data (feature layer) and ArcGIS online World Countries Generalised (https://hub.arcgis.com/datasets/2b93b06dc0dc4e809d3c8db5cb96ba69_0) feature layer. 

I did the join function to join the data together, and I'm wanting to display the data in the choropleth format. The survey123 data is each survey submission contains a field 'Country', which is selected from a dropdown list. I would like the count of the submission entries for each country.

When I open the stylize function of the new feature layer created from the join, and select COUNTRY FROM 'Choose and attribute to show', it doesn't give me the option of 'Counts and Amounts (color)' option which is what I need for the choropleth map. 

Below is what I'm getting:

JulietK_0-1614811863744.png

And this is what I am needing:

JulietK_1-1614811955697.png

 

Any idea why the option is not being offered? 

Thanks! 🙂

0 Kudos
8 Replies
JayantaPoddar
MVP Esteemed Contributor

You need to choose a numeric attribute to display style in Counts and Amounts.

Change Style - ArcGIS Online 



Think Location
0 Kudos
JulietK
Occasional Contributor II

Hi Jayanta, thank you for your response.

Any idea on how I could set up the Survey123 output so that the Counts and Amounts option will show up in the maps page? Since the name of the style included the word 'Count' I thought it would provide a count functionality within features. I am having difficulty finding any ESRI information material on creating choropleth maps from Survey123 data, so any information/advice would be really appreciated!

0 Kudos
JayantaPoddar
MVP Esteemed Contributor

Since you have already joined the Survey123 data to the World Countries data, what are the fields that you see in dropdown ("Choose an attribute to show")? You need to choose an appropriate numeric value from that.

In case you aren't able to figure it out, please share a screenshot of the dropdown showing the attributes of Survey123 data.



Think Location
0 Kudos
JulietK
Occasional Contributor II

It seems to only offer the fields from the World Countries feature layer, but the Survey123 data contains field 'Country' as well. 

JulietK_0-1614817901936.png

JulietK_1-1614817941409.png

I'm unsure why it is not giving me the fields from the Survey123 output? 

0 Kudos
JayantaPoddar
MVP Esteemed Contributor

I think"Join_Count" attribute should give you the count that you are looking for (unless the Join didn't work correctly and Join_Count is incorrect). Choose that attribute from drop-down.



Think Location
0 Kudos
JulietK
Occasional Contributor II

Thank you Jayanta, selecting the Join_Count option did offer up Counts and Amounts (color), which is great. 

JulietK_0-1615236026480.png

However, it doesnt seem to be getting the actual data from the correct dataset, as all countries are colored the same (the dataset it should be reading off only has about 10 entries in the 'Country' field, most of them of different countries). The Country data is in a Repeat layer, but for this Join_Feature layer I selected the parent layer as it was the only way to perform the join with 'Choose a spatial relationship'. I am suspecting that the above issue might be caused by the data in the Repeat layer not being able to be read, and only the parent layer data being available?

I tried Join_Features with the Repeat layer, but when I perform this I am only able to select 'Choose the fields to match' - I found that this results in a Table Hosted Layer, which doesn't give me the 'Change Style' button at all. Any ideas would be greatly appreciated!

0 Kudos
JayantaPoddar
MVP Esteemed Contributor

Could you confirm the min. and max. values of "Join_Count" field from the attribute table?

Also please share the screenshots of the attribute table, and the Options dialog (Counts and Amount)



Think Location
0 Kudos
JulietK
Occasional Contributor II

Hi Jayanta,

The feature layer of 'World Countries Generalised' joined with my Survey123 output parent layer shows 0 for all 'Join_Count' as below, and doesn't show any data from the Repeat of the survey123.

JulietK_0-1615246219488.png

JulietK_1-1615246273197.pngJulietK_3-1615246508059.png

 

 

And the feature table generated from 'World Countries Generalised' joined with my Survey123 Repeat layer doesn't give the 'changestyle' option at all, as below.

JulietK_2-1615246345362.png

Thank you

 

0 Kudos