I have a list of intersections within my dashboard and was trying to find a way to sequentially number the list using an Arcade expression, where the list would automatically update the list numbering as filters are applied to the intersection data. So, for example, if the intersections were ordered on the total number of crashes initially, with the order going from highest to lowest, it should look like the below example:
- W Broad St and Front: 100 Total Crashes
- Parsons Ave and E Livingston Ave: 80 Total Crashes
- N High St and 5th Ave: 35 Total Crashes
If the person looking at the data, selects to look at all intersections with bicycle involved crashes, then the list will change to show only intersections with bicycle involved crashes, with the order going from highest to lowest, and the intersection numbering should reflect as in the below example:
- S High St and Williams Rd: 8 Bicycle Involved Crashes
- Parsons Ave and Whittier Ave: 5 Bicycle Involved Crashes
- E Broad St and S James Rd: 3 Bicycle Involved Crashes
I know within ArcGIS Pro you can sequentially number a table, but is usually based off of a field like the Object ID. And it won't update the numbering if you filter for any other fields. From what I am seeing so far, I don't think this is possible, but thought I would reach out on here and see if someone with more experience using Arcade expressions might know how to accomplish this within my dashboard.