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; } } }

How can I configure the Arcade expression for Operations Dashboard to dynamically change data in widgets when map extent changes?

Norchevskyi

Hi,

I have the Arcade Expression (that was described here:ArcGIS Operations Dashboard Arcade Join Table ) for the Indicator widget, that perform a join operation between a feature layer and a feature table, I applied the rule "When map extent changes" in Map actions for the Indicator widget. But the Widget doesn't display the data, that is empty.

Is it possible to customize the Arcade expression so that the widget dynamically displays data from the current extent?

Thank you,

Roman

Find more posts tagged with

ArcGIS Online

Accepted answers

jcarlson

Your FeatureSet is being set to an empty geometry type, which is better for performance. To bring in the spatial component for map filtering, etc., you need to define the geometry type and include the geometry in your features array.

var joinedDict = {
    ...
    geometryType: "esriGeometryPoint" // or whatever geometry type applies
    ...
}

...

        joinedDict.features[i] = {
            attributes: {
                StreetID: tableID,
                Name: p["Address"],
				Depth: t["Depth"],
            },
            geometry: Geometry(p)
        }

...

All comments

ScoutStanley

For my project with using survey123 results, I found recreating within experience builder was the way to get it to work. Below is link to post I created. Hopefully that helps out some!

https://community.esri.com/t5/arcgis-dashboards-questions/how-do-you-connect-feature-set-dictionary-to/m-p/1263000#M7427

SupriyaK

I'm also trying to figure this out. Did you find a solution?

ScoutStanley

I am very new to data expressions and implementing within dashboards. I am having hard time figuring out how to get the geometry function to relate to my split choices. Basically, I have a survey123 with a multiple choice question (rent_amounts) and within the dashboard I have a sidebar category. The sidebar category I was able to split out the rent amount choices, but I can't figure out how to get it to filter with the map and address points inputted. Below is the current script. Here is link to dashboard Rental Dashboard

// Reference layer using the FeatureSetByPortalItem() function. 
var fs = FeatureSetByPortalItem(Portal('https://www.arcgis.com'), '288db7f54ea048c5b6241f156ef0f646' , 0, ['rent_amount'], false);

// Empty dictionary to capture each rental amount reported as separate rows. 
var choicesDict = {'fields': [{ 'name': 'split_choices', 'type': 'esriFieldTypeString'}], 
                    'geometryType': 'esriGeometryPoint', 'features': []}; 

var index = 0; 

// Split comma separated rental amounts and store in dictionary.  
for (var feature in fs) { 
    var split_array  =  Split(feature["rent_amount"], ',') 
    var count_arr = Count(split_array) 
    for(var i = 0; i < count_arr; i++ ){ 
        choicesDict.features[index++] = { 
            'attributes': { 'split_choices': Trim(split_array[i]),  
            }} 
}} 

// Convert dictionary to featureSet. 
var fs_dict = FeatureSet(Text(choicesDict)); 

// Return featureset after grouping by rental amounts. 
return GroupBy(fs_dict, ['split_choices'], 
       [{ name: 'split_count', expression: 'split_choices', statistic: 'COUNT' }]);

Norchevskyi

Josh, it's very strange, but when full extent we can see all counts of features, and when zooming we see 0 features

Thank you,

Roman

Norchevskyi

Yes, see please my screen:

Thank you,

Roman

jcarlson

You added the appropriate action to the map widget? I can get it to update just fine.

Norchevskyi

Josh, thank you for help. I added your your edits to the expression:

var portal = Portal("https://www.arcgis.com/");
var polyfs = FeatureSetByPortalItem(portal,"2c70f00e262a4488b266595720312617",0,["*"],true);
var tablefs = FeatureSetByPortalItem(portal,"227503e1ba6848baa7227b6311c04802",0,["*"],false);

var joinedDict = {
  fields: [
    { name: "StreetID", type: "esriFieldTypeInteger" },
    { name: "Name", type: "esriFieldTypeString" },	
    { name: "Depth", type: "esriFieldTypeDouble" },
  ],
    geometryType: "esriGeometryPoint",
'features':[]};

var i = 0;
for (var t in tablefs) {
    var tableID = t["StreetID"]
    for (var p in Filter(polyfs, "StreetID = "+tableID)){
        joinedDict.features[i] = {
            attributes: {
                StreetID: tableID,
                Name: p["Address"],
				Depth: t["Depth"],
            },
            geometry: Geometry(p)
        }
    }
i++
}

return FeatureSet(Text(joinedDict));

The widget is working but does not display data when map extent changes.

Thank you,

Roman

jcarlson

var joinedDict = {
    ...
    geometryType: "esriGeometryPoint" // or whatever geometry type applies
    ...
}

...

        joinedDict.features[i] = {
            attributes: {
                StreetID: tableID,
                Name: p["Address"],
				Depth: t["Depth"],
            },
            geometry: Geometry(p)
        }

...

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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