Calculating Feature Count of attribute type using arcade

EUngun — Tue, 12 Jul 2022 20:52:13 GMT

I would like to create a table using a feature layer like below to show total number of collisions occured on Street #1 and Street #2. Furthermore, I would like to color code the table according to their Highest Damage field. For example; if any of the street1# fields have "4 - Severe" as a highest damage that line in the table would be red, otherwise it will be colored according to the highest level of damage.

Street Name	Number of Collision	Highest Damage
Street1#	10	4 - Severe
Street1#	8	2 - Moderate
Street1#	6	2 - Minor
Street1#	7	2 - Moderate
Street2#	5	3 - Major
Street2#	20	2- Minor
Street2#	30	3 - Major

Ideally, I would like to have something similar to table below.

Street Name	Count of the Total Collision
Street1#	36
Street2#	50

The list element in arcgis dashboard does not have the group values settings but I can colored code them using arcade (when logical function). On the other hand, the table element has the group values settings but if I group them by street name I could calculate the sum of the number of collision but I could not color code them by highest damage. So how could I merge this to things together?

Is it possible to achieve this by advanced formatting in Arcade?

Any help ideas, code examples would be appreciated. Thanks!

topic Calculating Feature Count of attribute type using arcade in ArcGIS Dashboards Questions

Calculating Feature Count of attribute type using arcade