nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

GregReinecke

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.

Find more posts tagged with

ArcGIS Online

Accepted answers

WFNSProject

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.

All comments

ShengdiZhang

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

jcarlson

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

WFNSProject

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.

Kara_Shindle

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.