topic Re: Dashboard Arcade expression to use data from 2 fields for a List Element in ArcGIS Dashboards Questions

Dashboard Arcade expression to use data from 2 fields for a List Element

JohnEsch1 — Wed, 10 Jan 2024 18:24:56 GMT

I have an ArcGIS Dashboard and a List element where I want to use 2 separate fields: called {Well_Name} and {FacilityName}. By just putting in both fields I get an unsatisfactory list, where if there is not a Well_Name attribute, but a FacilityName attribute, it puts a NA in front of the FacilityName. The opposite occurs if there is Well_Name attribute, but not a FacilityName, by putting a N/A after the Well_Name. There must be a way to populate a List element from 2 separate fields. Would this be easier as an Arcade expression in the web map popup or in the Dashboard?

Re: Dashboard Arcade expression to use data from 2 fields for a List Element

marksm_macomb — Wed, 10 Jan 2024 19:14:32 GMT

If you click "Enable" in the advanced formatting section, you can create your own arcade variables to use in your list. So if it's a case where both names could be populated, it might look something like:

var wellNameFormatted = Iif($datapoint.Well_Name == "N/A", "", $datapoint.Well_Name) var facilityNameFormatted = Iif($datapoint.FacilityName == "N/A", "", $datapoint.FacilityName) return { textColor: '', backgroundColor: '', separatorColor:'', selectionColor: '', selectionTextColor: '', attributes: { Well: wellNameFormatted, Facility: facilityNameFormatted } }

And then you would reference it in your list as {expression/Well}{expression/Facility}

Or if it's only possible for one or the other to have a name, you could do it with one variable like this:

var nameFormatted = Iif($datapoint.Well_Name == "N/A", $datapoint.FacilityName, $datapoint.Well_Name) return { textColor: '', backgroundColor: '', separatorColor:'', selectionColor: '', selectionTextColor: '', attributes: { Name: nameFormatted } }

And just reference {expression/Name}

Re: Dashboard Arcade expression to use data from 2 fields for a List Element

JohnEsch1 — Wed, 10 Jan 2024 20:17:32 GMT

Thank you very much, it worked like a charm!