Arcade Expression for counts

Question

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.

NWEdisonTeam · Answer

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] 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 image008.png image007.png image005.png image004.png image009.png image003.png

XanderBakker · Answer

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.

NWEdisonTeam · Answer

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] 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 image007.png image008.png image009.png image003.png image004.png image005.png