topic Re: Text box inside Card widget, how to calculate total with two fields in ArcGIS Experience Builder Questions

Text box inside Card widget, how to calculate total with two fields

SanchezNuñez — Mon, 03 Nov 2025 13:36:15 GMT

Good morning,

Is there a way to calculate the Count() using two fields instead of one? I am looking for a way find the frequency of two fields together. Something like Count(field1, field2)

This is the SQL statement:

SELECT COUNT(*) AS total_records
FROM (
SELECT DISTINCT
[field1],
[field1]
FROM MyLayer
) AS distinct_records;

Re: Text box inside Card widget, how to calculate total with two fields

Ke_Xu — Tue, 04 Nov 2025 01:08:03 GMT

Hi @SanchezNuñez,

Text widget supports Arcade. Arcade expressions can be used for calculation.

Thanks,

Re: Text box inside Card widget, how to calculate total with two fields

JoseSanchez — Tue, 04 Nov 2025 18:47:25 GMT

Good morning Could you please provide a sample of this calculation that involves two variables in Arcade for this case.

This is the sample I got from Copilot:

var ds = $dataSource; // references the feature layer
var combos = [];

for (var feature in ds) {
combos[Count(combos)] = feature.RECORD_BOOK + "-" + feature.PAGE;
}

var distinctCombos = Distinct(combos);
return Count(distinctCombos);

I do not understand how to insert this code in the text widget:

This is the default code generated in the test widget Arcade:

function getFilteredFeatureSet(ds) {

var result = ds.layer;

var queryParams = ds.queryParams;

if (!IsEmpty(queryParams.where)) {

result = Filter(result, queryParams.where);

}

if (!IsEmpty(queryParams.geometry)) {

result = Intersects(result, queryParams.geometry);

}

return result;

}

Thanks

@Ke_Xu