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

2897
5
11-28-2016 10:53 AM
MegDavidson
New Contributor

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

0 Kudos
5 Replies
KellyGerrow
Esri Frequent Contributor

Hi Meg,

When you look at the JSON of the webmap: 

http://www.arcgis.com/sharing/rest/content/items/8c6ada8d2814409aa881e52843211923/data?f=pjson , the Neighbourhood Grocery Network is a feature collection that is stored in the web map. The UOS field is identified as a string field:

{
"name": "UOS",
"type": "esriFieldTypeString",
"alias": "UOS",
"sqlType": "sqlTypeNVarchar",
"length": 256,
"nullable": true,
"editable": true,
"domain": null,
"defaultValue": null
}

How did you publish this data? Was it by adding a csv file directly to the map? If so, try publishing this as a hosted feature service. You will be prompted to select the correct data type during the publishing process. 

Also, feel free to share the datasource and I can look into why the datatype was incorrectly set.

-Kelly

0 Kudos
MegDavidson
New Contributor

Hi Kelly,

Thanks for the help!

I tried to upload this CSV as a hosted feature service but I am unable to publish due to my privileges. I have a free account and I’m not sure it’s possible for me to change my privileges with this type of account.

I attached the CSV here to see if you might be able to offer any insight into why the datatype was initially incorrectly set.

Thank you for your help!

Meg

Meg Davidson

Sr. Program Mgr. – Analytics

(415) 282-1907, ext. 225

www.sfmfoodbank.org<http://www.sfmfoodbank.org/>

Find us on Twitter<https://twitter.com/SFMFoodBank> and Facebook<https://www.facebook.com/sfmfoodbank>

Do you believe in Food For All?

Take the pledge<http://org2.salsalabs.com/o/5420/p/salsa/web/common/public/signup?signup_page_KEY=9808> to help end hunger in our community.

0 Kudos
KellyGerrow
Esri Frequent Contributor

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.

0 Kudos
MegDavidson
New Contributor

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<http://www.sfmfoodbank.org/>

Find us on Twitter<https://twitter.com/SFMFoodBank> and Facebook<https://www.facebook.com/sfmfoodbank>

Do you believe in Food For All?

Take the pledge<http://org2.salsalabs.com/o/5420/p/salsa/web/common/public/signup?signup_page_KEY=9808> to help end hunger in our community.

0 Kudos
AndreaCase
New Contributor

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? 

0 Kudos