topic Re: Arcade Data Expression - "Unable to execute script" in ArcGIS Dashboards Questions

Arcade Data Expression - "Unable to execute script"

C_McNamara — Tue, 28 Feb 2023 15:05:01 GMT

Hello!

I am new to using arcade in dashboards and, hopefully, am making a simple mistake. I am trying to create an indicator from 2 different services (sum of Approved Dwelling Units). I am returning the correct value in the "Edit data expression" page but when I click done I am unable to use the expression - Esri says "Unable to execute script".

This is what my code currently looks like. This is my first time calculating values with different layers using FeatureSetByPortalItem

Code:

var PrelimPlans = FeatureSetByPortalItem(

Portal('https://www.arcgis.com/'),

'2a7c6c6f86b14253b1ecf079e3f4e6dd',

['Name', 'APPR_DU_TOT', 'Count'],

false

);

//Count(PrelimPlans);

var PrelimDUTOT = Sum(PrelimPlans,'APPR_DU_TOT');

//Return PrelimDUTOT

var SitePlan = FeatureSetByPortalItem(

Portal('https://www.arcgis.com/'),

'33c2a66277c34153907ba5d14484a24b',

['Name', 'APPR_DU_TOT', 'Count'],

false

);

//Count(SitePlan);

Sum(SitePlan,"APPR_DU_TOT")

var SitePlanDUTOT = Sum(SitePlan,'APPR_DU_TOT');

//Return SitePlanDUTOT

var CombinedDwellingUnits = PrelimDUTOT + SitePlanDUTOT;

Return CombinedDwellingUnits

***

Any help would be greatly appreciated!

All the best,

Colin

Re: Arcade Data Expression - "Unable to execute script"

jcarlson — Tue, 28 Feb 2023 15:59:50 GMT

A Data Expression needs to return a FeatureSet, where your expression is just returning a number.

The simplest way to do this would be to wrap your number in a single-feature FeatureSet, like this:

return FeatureSet(Text({ fields: [{name: 'the_count', type: 'esriFieldTypeInteger'}], geometryType: '', features: [{attributes: {the_count: CombinedDwellingUnits}}] }))

Put that in instead of your final return line, see if it works.

Re: Arcade Data Expression - "Unable to execute script"

C_McNamara — Tue, 28 Feb 2023 16:17:57 GMT

Works!

Thanks, Josh!

Re: Arcade Data Expression - "Unable to execute script"

C_McNamara — Tue, 28 Feb 2023 18:00:15 GMT

Hey Josh (@jcarlson),

Is it possible to combine these two layers together by creating a dynamic FeatureSet with a whole bunch of similar variables to visualize summarized stats like the problem above?

So, instead of creating a sum in the data expression, I would access a combined table or FeatureSet with 9,669 records (sum/join of my Preliminary plans and Site Plans).

Re: Arcade Data Expression - "Unable to execute script"

jcarlson — Tue, 28 Feb 2023 18:15:00 GMT

Yes, that's definitely possible! It can take a bit longer, since the only way to merge two featuresets is to do it feature by feature, but it shouldn't be too bad.

Here is an example expression that does just that:

https://github.com/Esri/arcade-expressions/blob/master/dashboard_data/CombineMultipleLayers(SerialChart).md

Never mind that it's for a Serial Chart, you can use the same thing for an indicator.

Re: Arcade Data Expression - "Unable to execute script"

C_McNamara — Tue, 28 Feb 2023 18:26:29 GMT

Think I got it!!