topic Re: Help with a expression to count features only where criteria is matched in ArcGIS Experience Builder Questions

Help with a expression to count features only where criteria is matched

Laura_m_Conner — Fri, 16 Jan 2026 21:04:34 GMT

All,

In Arc GIS online, in an experience i am building i have text box that i want to show the count of all selected data where a "field" matches a "value". I got the text box set up linked to the data. I am adding the dynamic text. In the expression dialog window what expression in the expression box do I put? so far AI and my own attempts have failed. Is this even posable to do in this manner? If not what is there an approach I use can that avoids having to making a view and filtering it on the field?

Thanks

Re: Help with a expression to count features only where criteria is matched

Ke_Xu — Tue, 20 Jan 2026 02:36:50 GMT

Hi @Laura_m_Conner,

Please use Arcade in Experience Builder. The help link is here: https://doc.arcgis.com/en/experience-builder/latest/configure-widgets/advanced-formatting.htm#ESRI_SECTION1_573128B984C64FBA9FEC507C66383145

Thanks,

Re: Help with a expression to count features only where criteria is matched

Laura_m_Conner — Tue, 20 Jan 2026 13:24:37 GMT

That is what I am trying to do. The problem is I can not figure out the syntax for it.

Re: Help with a expression to count features only where criteria is matched

KenBuja — Tue, 20 Jan 2026 15:08:32 GMT

This code should work. You'll have to replace the datasource ID with your own and supply the correct field name in the sql statement.

var ds = $dataSources["dataSource_1-19123c9cd36-layer-2"]; var layer = $dataSources["dataSource_1-19123c9cd36-layer-2"].layer; var sql = "yourField = value" //or "yourField = 'value'" if it's a string var filteredLayer = Filter(layer, sql) var output = Count(filteredLayer) return { value: output, text: { // size: 14, // color: 'rgb(0, 0, 255)', // bold: true, // italic: false, // underline: false, // strike: false }, };

This is what it looks like in while editing the Text widget. "Feature Count" is the name of the Arcade script.

And this is what the final result is

Re: Help with a expression to count features only where criteria is matched

Laura_m_Conner — Fri, 23 Jan 2026 16:18:33 GMT

all,

sorry for the delay. I am bouncing between projects.

Ok I have gotten in to the arcade widow in the text box to past my code. your code is giving me an invalid expression warning when i try to modify it. How do i find my datasource ID for the layer i want to use? also on this note I am going to try and make a arc GIS solution out if it. the idea is for people to change in their data layer for the template data layer i have set up. is this kind of data source connection going to cause it to brake when the substation happens?

i got the flowing code to return true / false if a feature matching the criteria is selected but cant figure out how to modify it return the count. can that be done? the code is:

Also resources on this would also be helpfull.

Laura

Re: Help with a expression to count features only where criteria is matched

KenBuja — Fri, 23 Jan 2026 18:38:00 GMT

Try this script

To get the correct layer, after you've connected the text box to your data, click edit, then the Arcade button. Put your cursor on line 24 after the =. On the side of the script editor is the Profile variable button. Click it, then click the arrow on right side of the $datasources line. Click the first line below that which has your datasource ID to add it to your script.

(view in My Videos)

Re: Help with a expression to count features only where criteria is matched

Laura_m_Conner — Fri, 23 Jan 2026 20:24:57 GMT

Thanks i try it as soon as I get a chance

Re: Help with a expression to count features only where criteria is matched

Laura_m_Conner — Fri, 30 Jan 2026 13:28:47 GMT

That code did not work. it kept giving me in valid syntax error. I was able spring board off of it and managed to get something that worked:

// Count selected meters where CRITICAL = 1 var fs = $dataSources["dataSource_1-19bc841fd0e-layer-7"].selectedFeatures; // If nothing is selected, show 0 if (IsEmpty(fs)) { return 0; } // Count only critical meters within the selection return Count(Filter(fs, "CRITICAL = 1"));

Do you know of any where I can learn the basic syntax rules of arcade? knowing the formal rules would be helpful in trying to compile code for various things.

Re: Help with a expression to count features only where criteria is matched

KenBuja — Fri, 30 Jan 2026 14:00:41 GMT

Start with the Arcade documentation, which contains lots of information about how to use the language, especially in the Language features section.

Re: Help with a expression to count features only where criteria is matched

Laura_m_Conner — Fri, 30 Jan 2026 16:01:08 GMT

Thanks Will Do.