topic Re: Dashboard Indicator that sums different layers in ArcGIS Dashboards Questions

Dashboard Indicator that sums different layers

aprhyde11 — Wed, 27 Sep 2023 19:13:14 GMT

Is it possible to create an Indicator that combines an attribute from different layers? I have a cost attribute for points, lines, and polygons layers and I want to combine them for an Overall Cost indicator.

I haven't been able to find a direct answer from my searching

Please let me know if there are further questions!

Re: Dashboard Indicator that sums different layers

marksm_macomb — Wed, 27 Sep 2023 20:29:47 GMT

You will need to write a data expression to combine features from multiple layers into one FeatureSet.

Some other resources:

Solved: Dashboard Data Expression to Combine Multiple Feat... - Esri Community

arcade-expressions/dashboard_data/CombineMultipleLayers(SerialChart).md at master · Esri/arcade-expressions · GitHub

At the most basic, your data expression may look like this:

But you can do more with grouping, summing, etc. if you have different categories that you want to sum by.

Re: Dashboard Indicator that sums different layers

jcarlson — Thu, 28 Sep 2023 13:30:36 GMT

@marksm_macomb has the right answer, but I'd like to mention that the basic "loop through features" approach can get very long if your layers have a lot of features. Using aggregate functions like Sum will evaluate a lot faster, and if all you need is the total cost summed, you can do it this way:

var portal = Portal('Portal URL') var fsets = [ FeatureSetByPortalItem(portal, 'ItemID', layerID, ['COST'], false), FeatureSetByPortalItem(portal, 'ItemID', layerID, ['COST'], false), FeatureSetByPortalItem(portal, 'ItemID', layerID, ['COST'], false) ] var running_sum = 0 for (var set in fsets) { running_sum += Sum(set, 'COST') } return FeatureSet({ fields: {name: 'total_cost', type: 'esriFieldTypeInteger'}, // or whatever field type it is geometryType: '', features: [{attributes: {total_cost: running_sum}}] })

Your output will be a single feature with a single field: the total.

If you need the output to be dynamic, responding to filters, etc, then you will need to do it the long way, looping through everything. And don't forget that if you do want to filter these in some way, all of those fields you're filtering by will need to be in the output as well.

Re: Dashboard Indicator that sums different layers

SIG-EscutismoCNE — Wed, 07 Aug 2024 13:00:10 GMT

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}}]