# Filtering on a variable(s) for a table analytics

**URL:** <https://community.tulip.co/t/filtering-on-a-variable-s-for-a-table-analytics/5174>\
**Category:** Support, Troubleshooting, & Help\
**Created:** [May 6, 2022, 7:15pm UTC](https://community.tulip.co/t/filtering-on-a-variable-s-for-a-table-analytics/5174 "2022-05-06T19:15:09Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![wkurth4008](https://avatars.discourse-cdn.com/v4/letter/w/c2a13f/32.png) [@wkurth4008](https://community.tulip.co/u/wkurth4008)\
**Post date:** [May 6, 2022, 7:15pm UTC](https://community.tulip.co/t/filtering-on-a-variable-s-for-a-table-analytics/5174/1 "2022-05-06T19:15:09Z")

</div>

Hi all, this doesn’t seem like it should be so difficult to do. I have a table of ‘failure causes’, which is basically a table of work order, a discrete failure code, and a qty, which for now is just 1 for each row. I am able to build a pareto chart for the whole table but I’d like to filter out based on the work order, which might be either a text or numeric field. How can I do this??

Thanks,

William

---

<div class="post-metadata">

**Author:** ![Pete\_Hartnett](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/pete_hartnett/32/3678_2.png) [@Pete\_Hartnett](https://community.tulip.co/u/Pete_Hartnett)\
**Post date:** [May 9, 2022, 2:08pm UTC](https://community.tulip.co/t/filtering-on-a-variable-s-for-a-table-analytics/5174/2 "2022-05-09T14:08:39Z")

</div>

Hey @wkurth4008,

This is totally something you can do within an app.

[https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/d/d5e5e1480fd33bce0ad1f11048c2481747189c4e.mov](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/d/d5e5e1480fd33bce0ad1f11048c2481747189c4e.mov)

The example dataset I have to work with is for audits, but this approach could easily be applied to your usecase. In this case I want to see audits by line, and I want to filter this analytic by if they passed or failed.

1. Make your analytic without your filter applied.  

2. Add it to an app.  

3. In the filters section, select the table field you want to filter on, and the variable you want to filter against.  

From there your analytic will dynamically update whenever a user updates the value of the filter variable.

Does this fit your need?  
Pete

---

<div class="post-metadata">

**Author:** ![wkurth4008](https://avatars.discourse-cdn.com/v4/letter/w/c2a13f/32.png) [@wkurth4008](https://community.tulip.co/u/wkurth4008)\
**Post date:** [May 9, 2022, 10:08pm UTC](https://community.tulip.co/t/filtering-on-a-variable-s-for-a-table-analytics/5174/3 "2022-05-09T22:08:17Z")

</div>

Yup! That works just like I wanted!! 😃

Thanks,

William

---

<div class="post-metadata">

**Author:** ![RussWaddell](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/russwaddell/32/3774_2.png) [@RussWaddell](https://community.tulip.co/u/RussWaddell)\
**Post date:** [May 11, 2022, 6:48pm UTC](https://community.tulip.co/t/filtering-on-a-variable-s-for-a-table-analytics/5174/4 "2022-05-11T18:48:03Z")

</div>