topic Re: Finding DISTINCT features using Arcade in List widget in Operations Dashboard in ArcGIS Web AppBuilder Questions

Finding DISTINCT features using Arcade in List widget in Operations Dashboard

LindaSlattery — Mon, 14 Mar 2022 20:05:24 GMT

I am trying to create a list with only distinct features from my table in Operations Dashboard. I am using the following Arcade script:

var provider = Distinct($datapoint["provider_name"])
return {
attributes: {
provider: provider
}
}

In the line item template in the list, I call it using {expression/provider}. I do not get any errors and it results in a provider name being listed, but I do not get unique names. Rather, it lists them all. Any ideas how to correct this?

Thanks!

Re: Finding DISTINCT features using Arcade in List widget in Operations Dashboard

jcarlson — Tue, 15 Mar 2022 03:31:48 GMT

The distinct function returns either an array or a FeatureSet, depending on the input.

The expression you have written here is in the dashboard formatting profile of Arcade, which cannot do what you're trying to accomplish. You're telling it to return the distinct values of the provider name of a single datapoint. The function treats this as an array with a single item in it:

Consider using a Data Expression, similar to this example.

Yours might look like this:

var portal = Portal('https://www.arcgis.com/'); var fs = FeatureSetByPortalItem( portal, 'your itemid', 0, ['provider_name'], false ); return Distinct(fs, 'provider_name')

Re: Finding DISTINCT features using Arcade in List widget in Operations Dashboard

EdmundEkanem1 — Tue, 05 Mar 2024 16:07:30 GMT

@jcarlson where do we insert this code, still in the advanced formatting? I am trying to do the same thing now. it also seems like the FeatureSetByPortalItem is not active on my end. Please could you any update on this?

Re: Finding DISTINCT features using Arcade in List widget in Operations Dashboard

jcarlson — Tue, 05 Mar 2024 16:37:39 GMT

Nah, follow the link in the original post. Data Expressions are separate data sources; you can create one when you define the data source for a widget.