nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Dashboard list shows status for sites who used Survey123 to report - is there way to show a list of sites NOT yet reported or join 2 layers in list?

LS1

In a nutshell we have 200+ locations reporting status on a daily basis using Survey123. I have a dashboard list showing status and a map showing a layer of all sites overlaid with the feature layer containing status. I have made the symbology work to identify which sites have not yet reported status. The endusers would rather have a list in the dashboard to identify sites that have NOT yet reported status, in real time. I don't know a way to do this. For example, 200 total sites and 190 have called in to report status inreal time. I want a list that shows the 10 that didn't call in. Is there a way to join 2 layers in a list in real time? Also, we are using Enterprice/portal not AGOL if that matters.

Vind meer berichten getagd met

Accepted answers

All comments

DfIRivers

We have an identical problem, and have taken various approaches to resolve. Like yourself we have used symbology to record assets that have been inspected and have an underlying layer that shows all the assets... so the colour and visibility of the underlying assets can highlight where inspections were missed, however our users still want a list of inspections missed.

So another approach was to use ModelBuilder to basically do what is essentially an MS Access Unmatched Query... not the most elegant solution for a number of reasons.

Be interested to see what other approaches have been applied... this must be a common enough workflow.

BobBooth1

Seems like you could query for features where the last reported data is greater than one day.

LS1

@BobBooth1 how do you filter dashboard list data list for features that don't exist? The list data is a Survey123 feature layer and contains records each day for locations reporting status. Some days they don't report status and they need to be called. I don't see any way to use more than 1 layer in dashboard list and/or how to create 1 layer in the dashboard web map and filter data to show locations that have not used Survey123 to report status. This all has to be done in real-time.

BobBooth1

If the survey is the same survey every day, then yesterday's features are there too, unless they get deleted by some process.

So perhaps an arcade query to compare the lists submitted yesterday and today as two feature sets?

https://community.esri.com/t5/arcgis-dashboards-questions/arcade-data-expression-match-ids-from-two-feature/td-p/1100750

LS1

@BobBooth1 Thank you. The survey is the same everyday but comparing today to yesterday doesn't guarantee that we have all locations, as yesterday not all locations may have submitted their status. I could create a "control set" with all locations with a date from past like 1/1/1900 and compare today's features to the control set, except I have never done more than formatting changes using arcade. I don't know how to compare the 2 feature layers using arcade and selecting the features from the control set layer that are NOT in the Survey123 layer. Help? Thank you!

BobBooth1

Something like this might work, if you made another hosted feature service of small buffers around the whole set of points, and then queried to report on the buffer features that do not have one of today's points inside them.

https://community.esri.com/t5/arcgis-online-questions/intersection-of-point-polyline-polygon-with-arcade/m-p/190821

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.