nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Esri Dashboard - Sum Different Layers (ArcGIS Online)

SIG-EscutismoCNE

Hello,

I’m trying to add two different layers but without success. Any suggestions?

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

var fsets = [

FeatureSetByPortalItem(portal, '8fadffa6772f428db8ffa703f9ebc61b', layerID, ['n_lobitos'], false),

FeatureSetByPortalItem(portal, '43e99df1123d454cb3d3e48ae5cfa462', layerID, ['n_lobitos'], false),

]

var running_sum = 0

for (var set in fsets) {

running_sum += Sum(set, 'n_lobitos')

}

return FeatureSet({

fields: {name: 'sum_n_lobitos', type: 'esriFieldTypeInteger'}, // or whatever field type it is

geometryType: '',

features: [{attributes: {sum_n_lobitos: running_sum}}]

})

Find more posts tagged with

Accepted answers

All comments

SIG-EscutismoCNE

Any help?

SIG-EscutismoCNE

Hello,

I’m trying to write an expression in the dashboard to add two layers in a certain field (n_lobitos in both)

I’m not getting it. Any help?

I’ve seen the sample below but it’s different.

https://github.com/Esri/arcade-expressions/blob/master/dashboard_data/CalculationAcrossFields.md

----------------------------------------------------------------------------------

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

var fs = [

FeatureSetByPortalItem(portal, '8fadffa6772f428db8ffa703f9ebc61b', layerID, ['n_lobitos'], false),

FeatureSetByPortalItem(portal, '43e99df1123d454cb3d3e48ae5cfa462', layerID, ['n_lobitos'], false),

]

var running_sum = 0

for (var set in fsets) {

var set_sum = Sum(fsets[set], 'n_lobitos')

Console('featureset sum:', set_sum)

running_sum += set_sum

Console('running sum:', running_sum)

}

return FeatureSet({

fields: {name: 'sum_n_lobitos', type: 'esriFieldTypeInteger'}, // or whatever field type it is

geometryType: '',

features: [{attributes: {sum_n_lobitos: running_sum}}]

jcarlson

Sprinkle some Console functions in there to see how far it gets. When you test the expression, the Console tab will show you the output of those functions.

For instance, you could try this for the for loop:

for (var set in fsets) {
  var set_sum = Sum(fsets[set], 'n_lobitos')
  Console('featureset sum:', set_sum)
  running_sum += set_sum
  Console('running sum:', running_sum)
}

This will output what the individual FeatureSet's sum is, as well as the running sum for that iteration of the loop.

You might also try outputting information about the FeatureSets themselves, to see if your FeatureSetByPortalItem functions are returning legitimate sets.

for (var set in fsets) {
  Console(Count(fset))
}

SIG-EscutismoCNE

Hello Josh,

Thank you for your attention,

However I changed as suggested but still keeps the error.

Do you have any other suggestions?

Thanks,

jcarlson

The problem is right here:

for (var set in fsets) {
  running_sum += Sum(set, 'n_lobitos')
}

When you iterate over an array, that nested var is the index, not the item. If you included the line Console(set) in the loop, you'd see it return 0 and 1. That means your Sum expressions are:

Sum(0, 'n_lobitos')

and

Sum(1, 'n_lobitos')

Which of course, won't return anything.

The way to get each item of an array is to call the original array and then use the index variable to access it. Try using these lines in replacement of the ones quoted earlier:

for (var set in fsets) {
  running_sum += Sum(fsets[set], 'n_lobitos')
}

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.