Arcade in List Dashboard element

[DEI]

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? 

[Anonymous User]

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

[DEI]

Yes. GlobalID to GUID, 1:M.

[Anonymous User]

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]

Thanks! I'll check it out.