topic Re: Expression to count the number of features where a condition is true. in ArcGIS Experience Builder Questions

Expression to count the number of features where a condition is true.

GregReinecke — Fri, 14 Oct 2022 03:14:49 GMT

In ExB I'd like to count the number of features where the condition met is true. I have a number of features with a text field called "Is an Issue Flagged?". If the value is "Yes" (i.e True) then I'd like to count them. So if I have 6 features with the field Is an Issue Flagged = "Yes" I'd put a 6 in a dynamic text box.

Here is my expression that doesn't work: IF {Is an Issue Flagged?} = "Yes" THEN COUNT({ObjectID}) END

Thanks in advance.

Re: Expression to count the number of features where a condition is true.

Kara_Shindle — Fri, 14 Oct 2022 12:25:56 GMT

Where is this calculation in the experience? If you are able to use Arcade, I saw this Geonet response that filtered by the field and I think you could do something similar.

https://community.esri.com/t5/arcgis-online-questions/arcade-totaling-field-values-of-features-contained/m-p/603540#M30196

alternatively,

var fc = FeatureSetBYName($datastore, "layername", ["Is an issue flagged"], True); var cnt = 0; for (var yes in fc) { if (yes.is an issue lagged == "yes") { cnt += 1; } } return cnt;

I based the above off of a solution here: https://community.esri.com/t5/arcgis-pro-questions/attribute-rule-arcade-filter-function-issue/td-p/206017

Re: Expression to count the number of features where a condition is true.

WFNSProject — Mon, 17 Oct 2022 14:06:41 GMT

The approach is likely not an arcade solution but the approach you presented is perfect. I did actually use views in ExB and counted items from there. I was just trying to skip that step. Thanks you.

Re: Expression to count the number of features where a condition is true.

jcarlson — Mon, 17 Oct 2022 17:51:44 GMT

ExB doesn't have much in terms of expressions. Certainly not conditional statements. Data source views are (currently) the only way to accomplish this.

Re: Expression to count the number of features where a condition is true.

ShengdiZhang — Fri, 27 Jun 2025 07:37:06 GMT

Hi @GregReinecke ,

This feature is supported in the June 2025 AGOL release. You can now add an Arcade expression to the text widget.

Regards,

Shengdi