# Multiple Filter Keys in reports

**URL:** <https://forum.inductiveautomation.com/t/multiple-filter-keys-in-reports/68941>\
**Category:** Ignition\
**Created:** [January 23, 2023, 9:59pm UTC](https://forum.inductiveautomation.com/t/multiple-filter-keys-in-reports/68941 "2023-01-23T21:59:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![wschauer](https://avatars.discourse-cdn.com/v4/letter/w/ecccb3/32.png) [@wschauer](https://forum.inductiveautomation.com/u/wschauer)\
**Post date:** [January 23, 2023, 9:59pm UTC](https://forum.inductiveautomation.com/t/multiple-filter-keys-in-reports/68941/1 "2023-01-23T21:59:00Z")

</div>

Is there a way to use multiple filter keys within a report table?  
I have one Query that pulls data for the week and I am currently filtering it by day, I would also like to filter by shift. Both are rows returned within the initial query.  
Just trying to be efficient as I know we can just do multiple queries for each shift if needed.  
Thanks

---

<div class="post-metadata">

**Author:** ![nideyijuyidong](https://avatars.discourse-cdn.com/v4/letter/n/7cd45c/32.png) [@nideyijuyidong](https://forum.inductiveautomation.com/u/nideyijuyidong)\
**Post date:** [January 24, 2023, 3:38am UTC](https://forum.inductiveautomation.com/t/multiple-filter-keys-in-reports/68941/2 "2023-01-24T03:38:31Z")

</div>

I implemented multiple filter myself in python. You may have to write your own SQL in the Name Query to achieve.

---

<div class="post-metadata">

**Author:** ![srb](https://avatars.discourse-cdn.com/v4/letter/s/ecae2f/32.png) [@srb](https://forum.inductiveautomation.com/u/srb)\
**Post date:** [February 23, 2023, 12:30am UTC](https://forum.inductiveautomation.com/t/multiple-filter-keys-in-reports/68941/3 "2023-02-23T00:30:13Z")

</div>

@wschauer, Are you looking for something like this?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/0/e00d1738824b37e83508c3e1d1a125c41a7934c8.png)