# Pie chart filter

**URL:** <https://forum.inductiveautomation.com/t/pie-chart-filter/89546>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [April 26, 2024, 5:45pm UTC](https://forum.inductiveautomation.com/t/pie-chart-filter/89546 "2024-04-26T17:45:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mimoun\_el\_hajeby](https://avatars.discourse-cdn.com/v4/letter/m/ecb155/32.png) [@mimoun\_el\_hajeby](https://forum.inductiveautomation.com/u/mimoun_el_hajeby)\
**Post date:** [April 26, 2024, 5:45pm UTC](https://forum.inductiveautomation.com/t/pie-chart-filter/89546/1 "2024-04-26T17:45:59Z")

</div>

how to filter out some rows that are coming from a query ? i have a query that brings all the rows, some of them not needed. Thank you!

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [April 26, 2024, 6:15pm UTC](https://forum.inductiveautomation.com/t/pie-chart-filter/89546/2 "2024-04-26T18:15:41Z")

</div>

Modify the query.

---

<div class="post-metadata">

**Author:** ![ryan.white](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.white/32/73193_2.png) [@ryan.white](https://forum.inductiveautomation.com/u/ryan.white)\
**Post date:** [April 26, 2024, 6:16pm UTC](https://forum.inductiveautomation.com/t/pie-chart-filter/89546/3 "2024-04-26T18:16:02Z")

</div>

Either adjust your query to filter out the unused rows or create a script that loops through the returned dataset and removes the unused rows.
