Counts and Amounts (Size) Not Showing up as an option

Question

I just uploaded a layer to my map (Neighborhood Grocery Network) and the option to change the style to Counts and Amounts (Size) is not showing up, despite the fact that the Attribute I selected is a numerical field (UOS field).

Does anyone have suggestions as to why this is happening or how I can get Counts and Amounts (Size) to show up?  It worked on every other layer I added and they all came from the same data source and were uploaded from the same file format.

http://www.arcgis.com/home/webmap/viewer.html?webmap=8c6ada8d2814409aa881e52843211923

AndreaCase · Answer

I'm working on a school project and am having the same issue, though I don't see any commas in my data set. It's a pretty small one and I do not see the "Counts and Amounts (Size)" option anywhere. Any ideas?

Clark_County_Hospitals.csv

MegDavidson · Answer

Kelly! You’re my GIS hero! Thank you for figuring it out and for helping me understand what caused the issue in the first place so I can avoid it happening again. I really appreciate your help! Best, Meg Meg Davidson Sr. Program Mgr. – Analytics (415) 282-1907, ext. 225 www.sfmfoodbank.org Find us on Twitter and Facebook Do you believe in Food For All? Take the pledge to help end hunger in our community. image001.png

KellyGerrow · Answer

Thanks Meg,

It looks like there is a value that was causing the data type to be defined as a string. As this is a CSV, commas are used to separate values. There is a comma in one of the name fields which resulted in all of the fields of for that record being shifted over by one value adding a string value into the UOS field: Korean American Senior Services, Inc. To get this to use the correct field type, remove the comma from this title, or modify the csv so that this title is contained in single quotes.

I've attached your spread sheet with the single quotes workaround.

NGN.csv (2).zip