Arcade Expression for counts

1270
4
05-26-2020 04:15 PM
NWEdisonTeam
New Contributor II

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. 

Tags (1)
0 Kudos
4 Replies
XanderBakker
Esri Esteemed Contributor

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. 

0 Kudos
NWEdisonTeam
New Contributor II

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

0 Kudos
XanderBakker
Esri Esteemed Contributor

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.

0 Kudos
NWEdisonTeam
New Contributor II

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.

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

0 Kudos