https://community.esri.com/t5/arcgis-experience-builder-questions/dynamically-filter-data-shown-in-a-chart-widget/m-p/1571259#M16668 <P><STRONG>To filter data in your Experience Builder chart:</STRONG></P><OL><LI><STRONG>Find the data source:</STRONG> Figure out where your chart gets its information (it's likely a "Feature Service").</LI><LI><STRONG>Let users choose filters:</STRONG> Use widgets like text boxes or dropdowns to let users select how they want to filter the data.</LI><LI><STRONG>Write a smart SQL query:</STRONG> Create an SQL query that changes based on what the user selects.</LI><LI><STRONG>Tell the chart to use the new query:</STRONG> Apply the query to your chart's data source.</LI><LI><STRONG>Refresh the chart:</STRONG> Make the chart display the filtered data.</LI></OL><P>&nbsp;</P><LI-CODE lang="javascript">const textBox = app.getWidgetById('textbox1'); const chartWidget = app.getWidgetById('chart1'); const featureServiceDataSource = chartWidget.dataSource; textBox.on('change', (event) =&gt; { const userInput = event.target.value; const sqlQuery = `YourFieldName = '${userInput}'`; featureServiceDataSource.setQuery({ where: sqlQuery, outFields: ['*'], }); chartWidget.refresh(); console.log(`Applied SQL query: ${sqlQuery}`); });</LI-CODE><P>&nbsp;</P> Thu, 26 Dec 2024 04:15:07 GMT SumitMishra_016 2024-12-26T04:15:07Z https://community.esri.com/t5/arcgis-experience-builder-questions/dynamically-filter-data-shown-in-a-chart-widget/m-p/1571232#M16666 <P>Hi,</P><P>&nbsp;</P><P><SPAN>How can I use a custom SQL query with a Feature Service data source in Experience Builder to dynamically filter data shown in a Chart widget based on user input?</SPAN></P> Wed, 25 Dec 2024 10:42:55 GMT https://community.esri.com/t5/arcgis-experience-builder-questions/dynamically-filter-data-shown-in-a-chart-widget/m-p/1571232#M16666 JAYAKUMARKUMAR 2024-12-25T10:42:55Z https://community.esri.com/t5/arcgis-experience-builder-questions/dynamically-filter-data-shown-in-a-chart-widget/m-p/1571259#M16668 <P><STRONG>To filter data in your Experience Builder chart:</STRONG></P><OL><LI><STRONG>Find the data source:</STRONG> Figure out where your chart gets its information (it's likely a "Feature Service").</LI><LI><STRONG>Let users choose filters:</STRONG> Use widgets like text boxes or dropdowns to let users select how they want to filter the data.</LI><LI><STRONG>Write a smart SQL query:</STRONG> Create an SQL query that changes based on what the user selects.</LI><LI><STRONG>Tell the chart to use the new query:</STRONG> Apply the query to your chart's data source.</LI><LI><STRONG>Refresh the chart:</STRONG> Make the chart display the filtered data.</LI></OL><P>&nbsp;</P><LI-CODE lang="javascript">const textBox = app.getWidgetById('textbox1'); const chartWidget = app.getWidgetById('chart1'); const featureServiceDataSource = chartWidget.dataSource; textBox.on('change', (event) =&gt; { const userInput = event.target.value; const sqlQuery = `YourFieldName = '${userInput}'`; featureServiceDataSource.setQuery({ where: sqlQuery, outFields: ['*'], }); chartWidget.refresh(); console.log(`Applied SQL query: ${sqlQuery}`); });</LI-CODE><P>&nbsp;</P> Thu, 26 Dec 2024 04:15:07 GMT https://community.esri.com/t5/arcgis-experience-builder-questions/dynamically-filter-data-shown-in-a-chart-widget/m-p/1571259#M16668 SumitMishra_016 2024-12-26T04:15:07Z https://community.esri.com/t5/arcgis-experience-builder-questions/dynamically-filter-data-shown-in-a-chart-widget/m-p/1665953#M21641 <P><a href="https://community.esri.com/t5/user/viewprofilepage/user-id/760068">@SumitMishra_016</a>&nbsp;can you please explain more about this?&nbsp; Are you suggesting to add text or drop down widgets in addition to the chart widget, or to configure the query within the chart widget?&nbsp; thanks!</P> Fri, 14 Nov 2025 18:14:30 GMT https://community.esri.com/t5/arcgis-experience-builder-questions/dynamically-filter-data-shown-in-a-chart-widget/m-p/1665953#M21641 JanetSilb_Spike 2025-11-14T18:14:30Z