Sure, here's a post you can use for the Esri Community forum.
Hi everyone,
I'm working on an ArcGIS Experience Builder application and I'm trying to set up a way to filter a Chart widget dynamically. My goal is to allow users to select a company name from a list or dropdown, and then have the chart update to display data only for that selected company.
I've explored the Chart widget's settings and various options in Experience Builder, but I haven't been successful in finding a direct way to achieve this specific filtering functionality. I'm looking for a method where a user interaction (like selecting a company) directly filters the data source of the chart, thereby updating its display.
Has anyone successfully implemented this or something similar? Any guidance, examples, or pointers to relevant documentation would be greatly appreciated! I'm open to using other widgets in conjunction with the Chart widget if that's the common approach.
Thanks in advance for your help!
Hi IB3,
You can have this functionality by using the filter widget. Within the filter widget's data, click on "SQL Expression Builder"
Select the company name field is All.
Then click on the gear icon to the right and select "Ask for values". This will make your filter a dropdown that users can select.
Lastly, make sure the select "Apply this filter automatically" in the Create New Filter pane. Your chart will now only present values from the filtered features the user has selected.