Trying to create an Arcade Data Expression but is not working properly (Dashboards)

SantiagoMafla — Tue, 28 Oct 2025 20:04:58 GMT

Hi everyone!

I hope anyone reading this is having a great day.

I'm someone that is very new at creating dashboards and using ArcGIS online, so this is one question of many on my journey to learn as mucha as I can.

As mentioned on the tite I'm trying to create an Arcade Data Expression but is not working properly. In the set of data that I'm using there're 3 elements that I'm trying to integrate or make an operation with, these elements are:

Dependencies (String)
Climate change actions (String)
Percentage of advance of each action (Double)

I'm trying with arcade to create a data expression that allows me to know the total of advance of each dependency according to the amount of advance done adding all of the actions like:

Total advance of the dependency = sum(advance of each action of the dependency)/sum(number of actions of the dependency)

I'm doing it with this arcade code, but it hasn't worked even after multiple workarounds, any ideas what could be happening?

var portal = Portal('https://www.arcgis.com/');

var fs = FeatureSetByPortalItem(

portal,

'5877b34d02574ba1826801c46976e6c0',

[

'dependenciane', //Dependencies

'accioncc', //Climate change action

'avancevigencia1' //Percentage of advance of each action

false

);

var dependencias = GroupBy(

fs,

['dependenciane'],

[

{ name: 'sum_avance', expression: 'avancevigencia1', statistic:'SUM' },

{ name: 'count_acciones', expression: 'accioncc', statistic: 'COUNT' },

]

);

var promedios = [];

for (var d in dependencias) {

if (d.count_acciones > 0) {

Push(promedios, (d.sum_avance / d.count_acciones));

}

var total_promedio = 0;

if (Count(promedios) > 0) {

total_promedio = Average(promedios);

}

return Round(total_promedio, 2);

Thanks in advance

Re: Trying to create an Arcade Data Expression but is not working properly (Dashboards)

KenBuja — Tue, 28 Oct 2025 20:21:13 GMT

The first rule of data expressions is they have to return a FeatureSet. Your expression is only returning a number, so the easiest way to make that into a FeatureSet would be using this syntax for the return

return FeatureSet( { fields: [{ name: "Total", type: "esriFieldTypeSingle" }], features: [{ attributes: { Total: Round(total_promedio, 2) } }] } );

topic Re: Trying to create an Arcade Data Expression but is not working properly (Dashboards) in ArcGIS Online Questions

Trying to create an Arcade Data Expression but is not working properly (Dashboards)

Re: Trying to create an Arcade Data Expression but is not working properly (Dashboards)