topic Re: Count records where two fields have distinct values in ArcGIS Experience Builder Questions

Count records where two fields have distinct values

SanchezNuñez — Tue, 27 Aug 2024 17:55:19 GMT

Good afternoon,

I am looking for a way to count in a layer how many records have two fields distinct, and show the result in a text box.

Thanks

SanchezNuñez — Wed, 28 Aug 2024 11:18:07 GMT

This is what I need if I use a SQL Statement:

SELECT distinct
[ProjectNumber]
,[ProjectPage]
FROM ProjecTables

And the count will be

SELECT COUNT(*)
FROM (
SELECT distinct
[ProjectNumber]
,[ProjectPage]
FROM ProjecTables
) as dt

Please advise

ShengdiZhang — Fri, 27 Jun 2025 09:40:22 GMT

The text widget supports Arcade expressions in the June 2025 AGOL release.

You can use a script like this in your expression:

var ds = $dataSources["dataSource_id"].layer; var distinctItem = Distinct(ds, 'CNTRY_NAME'); return Count(distinctItem);

Regards,

Shengdi