https://community.esri.com/t5/arcgis-experience-builder-questions/experience-builder-pie-chart-with-where-statement/m-p/1677347#M22121 <P>Hey All,</P><P>I am setting up 2 pie charts in Experience Builder. The first one contains all of the locations in my data set. that is working as expected. For the second one, I need it to show only a specific subset of that data. Essentially I need a "Where field A = X" variable to limit the data that gets read into the pie chart. Hopefully this is simple, but being fairly new to this, I have not yet found a way to do this while poking around.&nbsp;</P><P>Also, Preferably this would be a static pie chart and not dynamic or dependent on a filter from the map data.&nbsp;</P> Mon, 12 Jan 2026 17:49:34 GMT FlightDeck 2026-01-12T17:49:34Z https://community.esri.com/t5/arcgis-experience-builder-questions/experience-builder-pie-chart-with-where-statement/m-p/1677347#M22121 <P>Hey All,</P><P>I am setting up 2 pie charts in Experience Builder. The first one contains all of the locations in my data set. that is working as expected. For the second one, I need it to show only a specific subset of that data. Essentially I need a "Where field A = X" variable to limit the data that gets read into the pie chart. Hopefully this is simple, but being fairly new to this, I have not yet found a way to do this while poking around.&nbsp;</P><P>Also, Preferably this would be a static pie chart and not dynamic or dependent on a filter from the map data.&nbsp;</P> Mon, 12 Jan 2026 17:49:34 GMT https://community.esri.com/t5/arcgis-experience-builder-questions/experience-builder-pie-chart-with-where-statement/m-p/1677347#M22121 FlightDeck 2026-01-12T17:49:34Z https://community.esri.com/t5/arcgis-experience-builder-questions/experience-builder-pie-chart-with-where-statement/m-p/1677360#M22124 <P>When configuring the data source for the chart, click the drop-down for the layer and then Create a view:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tmichael_wpjwa_0-1768243408750.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/146673iB6CC058825819AA3/image-size/medium?v=v2&amp;px=400" role="button" title="tmichael_wpjwa_0-1768243408750.png" alt="tmichael_wpjwa_0-1768243408750.png" /></span></P><P>This will allow you to add a filter to the data, and then use the filtered data as the source for the chart.</P> Mon, 12 Jan 2026 18:44:46 GMT https://community.esri.com/t5/arcgis-experience-builder-questions/experience-builder-pie-chart-with-where-statement/m-p/1677360#M22124 tmichael_wpjwa 2026-01-12T18:44:46Z