Field totals for entire layer

aroininen

Hello folks,

can someone put me in the right direction or provide an example for me of the following arcade statement?

I would like to display the  the sum of a field for the an entire  layer not just the selection. I would like to show the totals of three separate fields in an arcgis online popup

Example:

Field 1 Total (of all records)

Field 2 Total (of all records)

Field 3 Total (of all records)

any help will be appreciated

Thanks!

 

XanderBakker

Hi @aroininen ,

It is possible to apply a filter on the data. Have a look at the expression below. We define a SQL query (make sure you use a valid query and the correct field names). We use a Filter to apply the query and provide the filtered featureset to the sum functions.

// make sure you use the extact field name
var sql = "ServiceArea IN (1,4,5,8,9)"; 

// filter the layer with the query
var fs = Filter($layer, sql);

// get the totals
var Canc = Sum(fs, "F_CanConne_1");
var Reserved = Sum(fs, "F_Reserved_1");
var DeswPro = Sum(fs, "F_DesWpro_1");
var Total = Canc + Reserved + DeswPro;

// structure the result
var result = "CanConnect: " + CanC;
result += TextFormatting.NewLine + "Reserved: " + Reserved;
result += TextFormatting.NewLine + "DeswPro: " + Deswpro;
result += TextFormatting.NewLine + "Total: " + Total;

// return the result
return result;