topic Symbolize percent of total in AGOL webmap in ArcGIS Online Questions

Symbolize percent of total in AGOL webmap

JayJohnsonWashoeCounty — Tue, 05 May 2020 16:42:43 GMT

I have a point layer of zipcode centroids with an attribute value of COVID-19 cases for each zipcode. I am currently displaying counts per zipcode as "Counts and Amounts(size)" based on the value that attribute for each record.

What I would like to do instead is symbolize by "% of total cases". Is there a way to do this without adding a field to the zipcode centroids that contains the # total cases (sum of all records)? In other words, is there a way (Arcade or otherwise) to utilize the total summed value of an attribute field in a table without using a second field that explicitly contains that total value?

Re: Symbolize percent of total in AGOL webmap

MarkBockenhauer — Tue, 05 May 2020 23:11:06 GMT

Arcade FeatureSet can be used to get the information, but it is not use-able for symbol rendering. Here is an example using it in a Popup configuration.

https://www.arcgis.com/home/item.html?id=c2d3ddc1352548cbb76d29f611b86dea

var a = FeatureSetByName($datastore,"Deaths",['Deaths','Country_Region'],false)
var usa = filter(a, "Country_Region = 'US'")
var USAtotal = sum(usa,'Deaths')
return 'percentage of US Deaths '+ text(round(($feature.Deaths / USAtotal)*100,2)) +'% '+ textformatting.newline +$feature["Province_State"]+' deaths ' + text($feature.Deaths,'#,###') + ' / '+ 'US Total '+ text(USAtotal,'#,###')

Re: Symbolize percent of total in AGOL webmap

JayJohnsonWashoeCounty — Wed, 06 May 2020 14:53:50 GMT

Thanks Mark. Too bad that can't be used for symbolization, which would be very handy.