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#||30||3 - Major|
Ideally, I would like to have something similar to table below.
|Street Name||Count of the Total Collision|
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!