topic Re: How can I configure the Arcade expression for Operations Dashboard to dynamically change data in widgets when map extent changes? in ArcGIS Dashboards Questions

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

Norchevskyi — Tue, 04 Jan 2022 19:06:33 GMT

Hi,

I have the Arcade Expression (that was described here: 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

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

jcarlson — Tue, 04 Jan 2022 19:22:17 GMT

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) } ...

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

Norchevskyi — Tue, 04 Jan 2022 20:06:09 GMT

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

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

Thank you,

Roman

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

jcarlson — Tue, 04 Jan 2022 20:40:00 GMT

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

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

Norchevskyi — Tue, 04 Jan 2022 20:43:48 GMT

Yes, see please my screen:

Thank you,

Roman

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

Norchevskyi — Tue, 04 Jan 2022 20:53:44 GMT

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

(view in My Videos)

Thank you,

Roman

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

jcarlson — Tue, 04 Jan 2022 21:11:18 GMT

That is very strange indeed! I created a List widget and added a Flash action on it. It seems that the features are coming in with just two particular points in this area:

I noticed there are only two values that show up in the Street ID field, so that seems to correspond with this. I'm assuming these values should correspond with the points layer in your screenshots, though, right?

Should you maybe join these based on a matching address field, rather than the street id?

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

Norchevskyi — Tue, 04 Jan 2022 22:54:43 GMT

Josh, the dashhboard is working. It was my mistake, as is joined data had only two values for StreetID field. All is well, but it seems that this method can work with no more than a few hundred features, if there are several thousand features, then the dashboard takes a very long time to process the data.

Thank you so much for your help and time,

Roman

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

ScoutStanley — Mon, 06 Feb 2023 16:01:33 GMT

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' }]);

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

SupriyaK — Wed, 31 May 2023 15:27:28 GMT

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

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

ScoutStanley — Mon, 05 Jun 2023 16:30:51 GMT

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