Arcade in List Dashboard element

568
4
09-02-2021 11:58 AM
Labels (1)
DEI
by
Occasional Contributor

Hello!

Using the Fire Hydrant Inspection scenario as an example, is there a way to list in a Dashboard the existing Hydrant IDs that have not been inspected within a given time frame? I initially thought creating a join layer based on most recent 'Inspected On' date and then using something like if (IsEmpty(Inspected On)) to return a list but if that field is empty, there's no related Hydrant ID to refer back to. Does anyone have any ideas? 

0 Kudos
4 Replies
by Anonymous User
Not applicable

Are your inspections stored as records in a table related to something like a point feature class for the hydrants?

0 Kudos
DEI
by
Occasional Contributor

Yes. GlobalID to GUID, 1:M.

0 Kudos
by Anonymous User
Not applicable

This post has links to some resources that  I have found very helpful for working with related tables in Dashboards:  Related tables and Operations Dashboard.

DEI
by
Occasional Contributor

Thanks! I'll check it out.

0 Kudos