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!
