topic Re: Arcade Expression in Dashboard runs in testing, then Unable to execute Arcade script appears in ArcGIS Dashboards Questions

Arcade Expression in Dashboard runs in testing, then Unable to execute Arcade script appears

RichardCreek — Wed, 12 Jun 2024 18:29:07 GMT

Hello Community,

I am trying to determine why this arcade expression runs during testing, but then when I click "done" and go back to the "Select a layer" page to select the expression to use in a bar chart the data expression text is grayed out with an alert saying "Unable to execute Arcade script".

I've included my script below for reference, I would appreciate any assistance or explanation why this isn;t working as intended.

// sets portal url

var cobportal = Portal('https://bloomingtonin.maps.arcgis.com/');

// assign Crash Dataset variables

var crashDatasetID = '50b2634c8c9443f58cd004f1138ef7ea';var crashLayerID = 0;

// assign FeatureSet variables

var crashFs = FeatureSetByPortalItem(cobportal, crashDatasetID, crashLayerID, ['number_dead', 'gis_incapacitating'], true);

// Initialize counters

var totalDeaths = 0;var totalInjuries = 0;

// Iterate through the FeatureSet and calculate totals

for (var crash in crashFs) {

if (IsEmpty(crash.number_dead) == false && crash.number_dead > 0) {

totalDeaths += crash.number_dead;

}

if (IsEmpty(crash.gis_incapacitating) == false && crash.gis_incapacitating == 'Yes') {

totalInjuries += 1;

}

// Return the results as an array

return [totalDeaths, totalInjuries];

Re: Arcade Expression in Dashboard runs in testing, then Unable to execute Arcade script appears

marksm_macomb — Wed, 12 Jun 2024 18:51:45 GMT

Dashboard data expressions require a featureset to be returned, but you are returning an array. You may want to create a featureset that has a category and a count field, and populate those fields with your totals. So I imagine you'll want to end up with a featureset "table" that looks like this in order to make a bar chart from it.

Category	Count
Total Deaths	###
Total Injuries	###

Create a data expression—ArcGIS Dashboards | Documentation

Re: Arcade Expression in Dashboard runs in testing, then Unable to execute Arcade script appears

KenBuja — Wed, 12 Jun 2024 18:57:16 GMT

A data expression must return a FeatureSet.

// sets portal url var cobportal = Portal('https://bloomingtonin.maps.arcgis.com/'); // assign Crash Dataset variables var crashDatasetID = '50b2634c8c9443f58cd004f1138ef7ea';var crashLayerID = 0; // assign FeatureSet variables var crashFs = FeatureSetByPortalItem(cobportal, crashDatasetID, crashLayerID, ['number_dead', 'gis_incapacitating'], true); // Initialize counters var totalDeaths = 0;var totalInjuries = 0; // Iterate through the FeatureSet and calculate totals for (var crash in crashFs) { if (IsEmpty(crash.number_dead) == false && crash.number_dead > 0) { totalDeaths += crash.number_dead; } if (IsEmpty(crash.gis_incapacitating) == false && crash.gis_incapacitating == 'Yes') { totalInjuries += 1; } } // Return the results as a FeatureSet var theDict = { 'fields': [ {'name':'TotalDeaths', 'type':'esriFieldTypeInteger'}, {'name':'TotalInjuries', 'type':'esriFieldTypeInteger'} ], 'geometryType': '', 'features': [{ 'attributes': { 'TotalDeaths': totalDeaths, 'TotalInjuries': totalInjuries } }] }; return FeatureSet(theDict);

Re: Arcade Expression in Dashboard runs in testing, then Unable to execute Arcade script appears

RichardCreek — Wed, 12 Jun 2024 19:12:36 GMT

I am pretty new to Arcade, how would you group the above output by year? I have a collision_date field where the year could be extracted.

Re: Arcade Expression in Dashboard runs in testing, then Unable to execute Arcade script appears

KenBuja — Thu, 13 Jun 2024 13:18:56 GMT

You can do that with the GroupBy function. Esri has a GitHub site with data expression samples, with one on GroupBy.

You can add the year field to your FeatureSet using a modification of @jcarlson's Memorize function, then use GroupBy on it. This should work...but it's untested

**Edit...fixing field names. and more fixes

I was hoping to use an SQL expression to define the year from the collision-date field to avoid using the Memorize function, but I can never seem to get more complicated SQL expressions to work.

Re: Arcade Expression in Dashboard runs in testing, then Unable to execute Arcade script appears

RichardCreek — Thu, 13 Jun 2024 12:39:31 GMT

I'm a little confused about the order of this expression, is this appended to the original expression or run by itself? It did not run in Dashboards on its own.

Re: Arcade Expression in Dashboard runs in testing, then Unable to execute Arcade script appears

KenBuja — Thu, 13 Jun 2024 13:01:53 GMT

This is the whole expression. What do you get when you run in the code editor?

Re: Arcade Expression in Dashboard runs in testing, then Unable to execute Arcade script appears

RichardCreek — Thu, 13 Jun 2024 13:10:26 GMT

Test execution error: Unexpected token ')'.. Verify test data.

Re: Arcade Expression in Dashboard runs in testing, then Unable to execute Arcade script appears

KenBuja — Thu, 13 Jun 2024 13:17:43 GMT

I had to fix an error in line 13. There was an extra parenthesis at the end.

Re: Arcade Expression in Dashboard runs in testing, then Unable to execute Arcade script appears

RichardCreek — Thu, 13 Jun 2024 13:24:53 GMT

Test execution error: Aggregation field not found. Verify test data.

Re: Arcade Expression in Dashboard runs in testing, then Unable to execute Arcade script appears

KenBuja — Thu, 13 Jun 2024 13:48:54 GMT

Since I don't have access to your data, I've been using another dataset to do my testing. This version returns the expected FeatureSet. Can you modify it to use your data?

Re: Arcade Expression in Dashboard runs in testing, then Unable to execute Arcade script appears

RichardCreek — Thu, 20 Jun 2024 13:13:05 GMT

Ken if you could provide some additional assistance I'd really appreciate it, still stuck.

This is what I have now, but it's not correct:

// sets portal url

var cobportal = Portal('https://bloomingtonin.maps.arcgis.com/');

// assign Crash Dataset variables

var crashDatasetID = '50b2634c8c9443f58cd004f1138ef7ea';var crashLayerID = 0;

// assign FeatureSet variables

var crashFs = FeatureSetByPortalItem(cobportal, crashDatasetID, crashLayerID, ['number_dead', 'gis_incapacitating'], true);

function Memorize(fs) {

var fieldList = Schema(fs)['collision_date'];

Push(fieldList, {"alias":"Collision Year","editable":true,"length":4,"name":"collision_year","nullable":true,"type":"esriFieldTypeInteger"})

var temp_dict = {

fields: fieldList,

geometryType: '',

features: []

}

for (var f in fs) {

var attrs = {}

for (var attr in f) {

attrs[attr] = f[attr]

}

attrs['collision_year'] = Year(f['date'])

Push(

temp_dict['features'],

{attributes: attrs}

)

}

return FeatureSet(theDict);

var newFS = Memorize(fs)

var summaryFS = GroupBy(newFS, 'collision_year',

[

{name: 'Maximum magnitude', expression: 'magnitude', statistic: 'Max' }

]);

return summaryFS;

Re: Arcade Expression in Dashboard runs in testing, then Unable to execute Arcade script appears

KenBuja — Thu, 20 Jun 2024 13:43:00 GMT

When posting code, use the "Insert/Edit code sample" button. It makes your code easier to read and provide line numbers in your code.

Remember that I was using a different data set to show you how it would work, since I couldn't test it with your data and you were getting an execution error.

Do you still get that error when using this?

var summaryFS = GroupBy(newFS, 'collision_year', [ {name: 'number_dead', expression: 'TotalDeaths', statistic: 'SUM' }, {name: 'gis_incapacitating', expression: 'TotalInjuries', statistic: 'SUM' } ]);

Re: Arcade Expression in Dashboard runs in testing, then Unable to execute Arcade script appears

RichardCreek — Thu, 20 Jun 2024 13:54:48 GMT

Like this? it does not execute

Re: Arcade Expression in Dashboard runs in testing, then Unable to execute Arcade script appears

KenBuja — Thu, 20 Jun 2024 14:53:52 GMT

Try this

**Updated GroupBy expression

// sets portal url var cobportal = Portal('https://bloomingtonin.maps.arcgis.com/'); // assign Crash Dataset variables var crashDatasetID = '50b2634c8c9443f58cd004f1138ef7ea';var crashLayerID = 0; // assign FeatureSet variables var crashFs = FeatureSetByPortalItem(cobportal, crashDatasetID, crashLayerID, ['number_dead', 'gis_incapacitating'], true); function Memorize(fs) { var fieldList = Schema(fs)['fields']; Push(fieldList, {"alias":"Collision Year","editable":true,"length":4,"name":"collision_year","nullable":true,"type":"esriFieldTypeInteger"}) var temp_dict = { fields: fieldList, geometryType: '', features: [] } for (var f in fs) { var attrs = {} for (var attr in f) { attrs[attr] = f[attr] } attrs['collision_year'] = Year(f['date']) Push( temp_dict['features'], {attributes: attrs} ) } return FeatureSet(theDict); var newFS = Memorize(fs) var summaryFS = GroupBy(newFS, 'collision_year', [ {name: 'Total Deaths', expression: 'number_dead', statistic: 'SUM' }, {name: 'Total Injuries', expression: 'gis_incapacitating', statistic: 'SUM' } ]); return summaryFS;

Re: Arcade Expression in Dashboard runs in testing, then Unable to execute Arcade script appears

RichardCreek — Thu, 20 Jun 2024 15:12:09 GMT

Thank you so much for your continued assistance Ken, I really do appreciate it. Unfortunately, received this error: Test execution error: '}' expected.. Verify test data. It doesn't like somethin with line 40

Re: Arcade Expression in Dashboard runs in testing, then Unable to execute Arcade script appears

KenBuja — Thu, 20 Jun 2024 15:30:19 GMT

A few fixes I missed

// sets portal url var cobportal = Portal('https://bloomingtonin.maps.arcgis.com/'); // assign Crash Dataset variables var crashDatasetID = '50b2634c8c9443f58cd004f1138ef7ea';var crashLayerID = 0; // assign FeatureSet variables var crashFs = FeatureSetByPortalItem(cobportal, crashDatasetID, crashLayerID, ['number_dead', 'gis_incapacitating'], true); function Memorize(fs) { var fieldList = Schema(fs)['fields']; Push(fieldList, {"alias":"Collision Year","editable":true,"length":4,"name":"collision_year","nullable":true,"type":"esriFieldTypeInteger"}) var temp_dict = { fields: fieldList, geometryType: '', features: [] } for (var f in fs) { var attrs = {} for (var attr in f) { attrs[attr] = f[attr] } attrs['collision_year'] = Year(f['date']) Push( temp_dict['features'], {attributes: attrs} ) } return FeatureSet(temp_dict); } var newFS = Memorize(crashFs) var summaryFS = GroupBy(newFS, 'collision_year', [ {name: 'Total Deaths', expression: 'number_dead', statistic: 'SUM' }, {name: 'Total Injuries', expression: 'gis_incapacitating', statistic: 'SUM' } ]); return summaryFS;

Re: Arcade Expression in Dashboard runs in testing, then Unable to execute Arcade script appears

RichardCreek — Thu, 20 Jun 2024 15:35:43 GMT

Thanks Ken for taking another look, received this error: Test execution error: Execution error - Key not found - date. Verify test data.

I don't see in the expression where collision_date (the date field) is referenced, maybe I'm missing something?

Re: Arcade Expression in Dashboard runs in testing, then Unable to execute Arcade script appears

KenBuja — Thu, 20 Jun 2024 15:41:53 GMT

Two more changes. Line 8 should be

var crashFs = FeatureSetByPortalItem(cobportal, crashDatasetID, crashLayerID, ['number_dead', 'gis_incapacitating', 'collision_date'], true);

and line 25 should

attrs['collision_year'] = Year(f['collision_date'])

Re: Arcade Expression in Dashboard runs in testing, then Unable to execute Arcade script appears

RichardCreek — Thu, 20 Jun 2024 15:54:42 GMT

Really close Ken, output is not counting the injuries though, looks like this.

gis_incapacitating is a string field (Yes or No) and needs to be counted for 'Yes' records and then summed

Current expression iteration for reference:

// sets portal url var cobportal = Portal('https://bloomingtonin.maps.arcgis.com/'); // assign Crash Dataset variables var crashDatasetID = '50b2634c8c9443f58cd004f1138ef7ea';var crashLayerID = 0; // assign FeatureSet variables var crashFs = FeatureSetByPortalItem(cobportal, crashDatasetID, crashLayerID, ['number_dead', 'gis_incapacitating', 'collision_date'], true); function Memorize(fs) { var fieldList = Schema(fs)['fields']; Push(fieldList, {"alias":"Collision Year","editable":true,"length":4,"name":"collision_year","nullable":true,"type":"esriFieldTypeInteger"}) var temp_dict = { fields: fieldList, geometryType: '', features: [] } for (var f in fs) { var attrs = {} for (var attr in f) { attrs[attr] = f[attr] } attrs['collision_year'] = Year(f['collision_date']) Push( temp_dict['features'], {attributes: attrs} ) } return FeatureSet(temp_dict); } var newFS = Memorize(crashFs) var summaryFS = GroupBy(newFS, 'collision_year', [ {name: 'Total Deaths', expression: 'number_dead', statistic: 'SUM' }, {name: 'Total Injuries', expression: 'gis_incapacitating', statistic: 'SUM' } ]); return summaryFS;