topic show sum in cluster label in ArcGIS Online Questions

show sum in cluster label

forestknutsen1 — Tue, 10 Aug 2021 22:51:55 GMT

How do I get the sum not the average in my cluster label?

Re: show sum in cluster label

forestknutsen1 — Tue, 10 Aug 2021 23:08:50 GMT

I found one way to do it (line 3)... but if feels like it is not the best. I feel like I should be able to get the sum directly:

$feature["cluster_avg_CUSTOMERS_AFFECTED"]; var no_feature = $feature["cluster_count"]; var value = $feature["cluster_avg_CUSTOMERS_AFFECTED"] * no_feature; var num = Count(Text(Round(value))); var label = When( num < 4, Text(value, "#.#"), num == 4, Text(value / Pow(10, 3), "#.0k"), num <= 6, Text(value / Pow(10, 3), "#k"), num == 7, Text(value / Pow(10, 6), "#.0m"), num > 7, Text(value / Pow(10, 6), "#m"), Text(value, "#,###") ); return label;

Re: show sum in cluster label

KristianEkenes — Wed, 11 Aug 2021 16:00:05 GMT

Yep. That is one way to work around the issue for now. The problem with this, however is the size of the cluster doesn't adjust to use the sum. It still uses the average, which can lead to some really small sized clusters with larger numbers than clusters with a larger size.

This is something we should support. Still working on some details to help it fit with the existing API smoothly. No timeline at the moment.

Re: show sum in cluster label

forestknutsen1 — Wed, 11 Aug 2021 20:31:47 GMT

Thanks for the feedback Kristian. Yes, the sizing issue is likely a deal breaker for me. I may not be able to use clustering at all until esri improves things.

Re: show sum in cluster label

AndrewPadilla — Fri, 09 May 2025 18:47:43 GMT

Here is how I was able to get the sum of a field as the cluster label. You should be able to get the sum in the label by first adding a cluster field for CUSTOMERS_AFFECTED. selecting the statistic type you want.

Now you can use that expression in the cluster label field.