Select to view content in your preferred language

Using Arcade expression in Indicator Element to count sites with presence

106
0
3 weeks ago
ChristineTombleson1
Frequent Contributor

Hello -

I have a hosted feature layer (using a view layer in the dashboard) that includes several related layers and related tables to collect data on structures and marshes, etc. within the monitoring site. The main layer is "Monitoring Sites," which contains Global IDs. The related layers and tables also have Global IDs and GUIDs. There are two related layers and two related tables of related layers that contain fields about oysters within the monitoring sites.

My goal is to create an indicator element that shows the number of monitoring sites that have data recorded in any of the oyster info fields in the related layers or tables. I do not need a count of the oysters themselves, but rather a count of the monitoring sites that have non-null values in fields related to oyster information.

 Is this possible? Can this be done through an arcade expression? This is a live dashboard that must update automatically as new data is entered into Field Maps. 

Thank you so much for any guidance 

 

0 Kudos
0 Replies