https://community.esri.com/t5/arcgis-dashboards-questions/trouble-creating-a-data-expression-for-survey/m-p/1637051#M11311 <P>&nbsp;</P><P>I am trying to create a dashboard that will monitor travel locations using Survey123. The survey contains repeats just in case respondents travel to multiple countries.&nbsp;</P><P>I am not well versed in Arcade, but I am trying to create a data expression that takes a layer/table with a GlobalID. Finds related records in a child table/layer with a field ParentGlobalID then matches that GlobalID. From there, its returns related data so you can use it in a Dashboard element (list, chart, etc.).</P><P>I keep running into an issue where it can't find the $datastore. I have the web map set up correctly, but it keeps giving me an error saying "<SPAN>Test execution error: Compilation error - Line : 1,7 Identifier not recognized. Verify test data."</SPAN></P><P><SPAN>Any help is appreciated!</SPAN></P><LI-CODE lang="markdown">// Get parent layer (Survey) var parentLayer = FeatureSetByName($datastore, "Form_1", ["GlobalID"], false) // Get repeat layer (child) var repeatLayer = FeatureSetByName($datastore, "Travel Locations", ["ParentGlobalID", "Select the country You will be traveling to", "OBJECTID"], false) // Empty array for results var relatedRepeats = [] // Loop through parents for (var parent in parentLayer) { var parentID = parent["GlobalID"] // Find repeat features where ParentGlobalID matches this parent var repeats = Filter( repeatLayer, "ParentGlobalID = @parentID" ) // Add all matching repeats to results for (var r in repeats) { Push(relatedRepeats, r) } } // Return repeats as FeatureSet return FeatureSet(Text(relatedRepeats))</LI-CODE><P>&nbsp;</P> Mon, 28 Jul 2025 18:51:48 GMT DanielRutigliano 2025-07-28T18:51:48Z https://community.esri.com/t5/arcgis-dashboards-questions/trouble-creating-a-data-expression-for-survey/m-p/1637051#M11311 <P>&nbsp;</P><P>I am trying to create a dashboard that will monitor travel locations using Survey123. The survey contains repeats just in case respondents travel to multiple countries.&nbsp;</P><P>I am not well versed in Arcade, but I am trying to create a data expression that takes a layer/table with a GlobalID. Finds related records in a child table/layer with a field ParentGlobalID then matches that GlobalID. From there, its returns related data so you can use it in a Dashboard element (list, chart, etc.).</P><P>I keep running into an issue where it can't find the $datastore. I have the web map set up correctly, but it keeps giving me an error saying "<SPAN>Test execution error: Compilation error - Line : 1,7 Identifier not recognized. Verify test data."</SPAN></P><P><SPAN>Any help is appreciated!</SPAN></P><LI-CODE lang="markdown">// Get parent layer (Survey) var parentLayer = FeatureSetByName($datastore, "Form_1", ["GlobalID"], false) // Get repeat layer (child) var repeatLayer = FeatureSetByName($datastore, "Travel Locations", ["ParentGlobalID", "Select the country You will be traveling to", "OBJECTID"], false) // Empty array for results var relatedRepeats = [] // Loop through parents for (var parent in parentLayer) { var parentID = parent["GlobalID"] // Find repeat features where ParentGlobalID matches this parent var repeats = Filter( repeatLayer, "ParentGlobalID = @parentID" ) // Add all matching repeats to results for (var r in repeats) { Push(relatedRepeats, r) } } // Return repeats as FeatureSet return FeatureSet(Text(relatedRepeats))</LI-CODE><P>&nbsp;</P> Mon, 28 Jul 2025 18:51:48 GMT https://community.esri.com/t5/arcgis-dashboards-questions/trouble-creating-a-data-expression-for-survey/m-p/1637051#M11311 DanielRutigliano 2025-07-28T18:51:48Z