topic Re: Dynamic Content Expression in ArcGIS Experience Builder Questions

Dynamic Content Expression

JasonCyphers — Fri, 20 Nov 2020 14:23:07 GMT

Trying to have text that counts the number of records in a database in which a specific attribute is "Yes".

What formula do I need to enter into the Expression box, so that if 3 of the 5 records have "Yes" for a specific attribute, then the number displayed is "3"?

Re: Dynamic Content Expression

BrunoSousa1 — Fri, 20 Nov 2020 14:49:02 GMT

Hi Jason,

You can create a View of your layer within Experience Builder and filter to only the ones that say Yes. So, in the expression box you insert Count() and select which view the data is coming from, if it's default or the data view you created:

Create the Data View here:

Select the Data Views when you connect the widget to data

Insert COUNT() and select whitch data view it's counting from:

Let me know if this helps.

Best

Re: Dynamic Content Expression

JasonCyphers — Fri, 20 Nov 2020 15:43:43 GMT

Awesome, thanks!!

Is there, by chance, a way to perform a calculation to show the feature count, that has the attribute as "Yes", as a percentage of the total features in the database?

Re: Dynamic Content Expression

BrunoSousa1 — Fri, 20 Nov 2020 15:52:01 GMT

There is. You can add COUNT()/COUNT()*100, and select the data views for each COUNT(). However the result has lots of decimals and I don't know how to change that

Re: Dynamic Content Expression

JasonCyphers — Fri, 20 Nov 2020 16:09:23 GMT

Thanks again!!

haha, yea, need to figure out a way to format the text to limit the decimal places!

Re: Dynamic Content Expression

JasonCyphers — Wed, 25 Nov 2020 16:10:36 GMT

Is there a way to do any conditional formatting? If the expression resulted in a value 50% or more, could you format the text to be bole red, otherwise it remains the default?

Re: Dynamic Content Expression

TKSHEP — Wed, 30 Nov 2022 13:35:07 GMT

Any help you can provide would be greatly appreciated, I tried this, and it did not work. I am unable to get the count work properly. Any suggestions, I do not need the percentage just the correct number to show for all attributes with a "NO".

Thank you!

Re: Dynamic Content Expression

BrunoSousa1 — Wed, 30 Nov 2022 18:02:03 GMT

Hi Trisha. Did you select the DataView?

The DataView must be selected on the right side panel:

Then you must select the DataView before adding the Statistics "Count":

Let me know if it doesn't work

Re: Dynamic Content Expression

TKSHEP — Wed, 30 Nov 2022 19:25:35 GMT

Yes, I did and that still did not work. It shows a count but not the correct number of the number that is in the data view, data view records are correct not the text number.

Re: Dynamic Content Expression

Lucasrodri — Tue, 07 Mar 2023 14:13:18 GMT

Hi !!

Do you know a way to change the decimals now? Im overthinking with that hahaha

Re: Dynamic Content Expression

RobertAnderson3 — Wed, 18 Oct 2023 14:05:27 GMT

I know this was months ago, but if you're still struggling with this, next to the Insert when creating the expression there is a gear icon for settings, there is a number formatting option in there and you should be able to use that to decide how many decimals!

Re: Dynamic Content Expression

doronwen — Mon, 16 Dec 2024 16:39:39 GMT

Hey @BrunoSousa1

Does the expression builder for Dynamic content allows you to divide two sums?
I need to get a percentage calculated.

This is what I came up with, but it does not work:

(SUM({Material Capacity}))/(SUM({Material Inventory}))*100

How would you write it?

Thanks

Re: Dynamic Content Expression

Jake-MacLean — Thu, 18 Dec 2025 18:42:35 GMT

Hi Bruno,

Just came across this post and it is also not working for me.

Any pointers? When I fill it out all I see is COUNT({ObjectID})

I set up the data view and made sure the text widget was connected to it.

Thanks,

Jake