Arcade in List Dashboard element

258
4
09-02-2021 11:58 AM
DEI
by
New Contributor III

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
Lauren_Frick
New Contributor II

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

0 Kudos
DEI
by
New Contributor III

Yes. GlobalID to GUID, 1:M.

0 Kudos
Lauren_Frick
New Contributor II

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
New Contributor III

Thanks! I'll check it out.

0 Kudos