topic Re: Arcade Expression for counts in ArcGIS Online Questions

Arcade Expression for counts

NWEdisonTeam — Tue, 26 May 2020 23:15:11 GMT

Hi All,

I am looking for an arcade expression to display the following:

I have 3 categories

1. yes

2. no

3. other

each with counts. Is there a way to express both the text category and the associated counts using an arcade expression. I tried to sum/count the text strings and it didn't go how I thought. Any help would be appreciated.

Re: Arcade Expression for counts

XanderBakker — Wed, 27 May 2020 13:23:31 GMT

Hi NWEdison Team ,

Could you elaborate a little more on what you have (what kind of data) and what you are trying to achieve. You can get information of counts in a pop-up, but not dynamically in the symbology without having a field that contains the count.

Re: Arcade Expression for counts

NWEdisonTeam — Wed, 27 May 2020 15:33:38 GMT

You pretty much answered my question as what I was attempting to do was to have the number appear in the symbology. Thanks!

[Tirrell Brown GIS Analyst Northwest Edison at Industrial Light & Energy, Inc. O 425.806.9200 | m 425.420.4672 | f 425.806.7455 DUNS: 039367516 CAGE: 3k3b9]

<https://www.facebook.com/Northwest-Edison-631874700167141/> <https://www.instagram.com/northwest_edison/> <https://www.linkedin.com/company/northwest-edison/> <mailto:tirrellb@nwedison.com>

Please consider the environment before printing this email.

This email may contain information that is confidential or attorney-client privileged and may constitute inside information. The contents of this email are intended only for the recipient(s) listed above. If you are not the intended recipient, you are directed not to read, disclose, distribute or otherwise use this transmission. If you have received this email in error, please notify the sender immediately and delete the transmission. Delivery of this message is not intended to waive any applicable privileges

Re: Arcade Expression for counts

XanderBakker — Wed, 27 May 2020 21:46:39 GMT

Hi NWEdison Team ,

For now, one of the ways you can do this is to use a field calculation and store the result in a field. However, if your data is dynamic (and in most cases it is) this will requiere repeating the calculation with a certain interval. If you need help with the Arcade expression to do this calculation, just let me know.

Re: Arcade Expression for counts

NWEdisonTeam — Thu, 28 May 2020 15:13:00 GMT

Sorry for my late reply. Our data is indeed dynamic, but I think the easier thing to do is roll that info into a dashboard for easy digestion for our non GIS folks. Thanks for your help!

[Tirrell Brown GIS Analyst Northwest Edison at Industrial Light & Energy, Inc. O 425.806.9200 | m 425.420.4672 | f 425.806.7455 DUNS: 039367516 CAGE: 3k3b9]

<https://www.facebook.com/Northwest-Edison-631874700167141/> <https://www.instagram.com/northwest_edison/> <https://www.linkedin.com/company/northwest-edison/> <mailto:tirrellb@nwedison.com>

Please consider the environment before printing this email.