# Filter Greater Than in Table Visualization

**URL:** https://discuss.elastic.co/t/filter-greater-than-in-table-visualization/173070
**Category:** Kibana
**Created:** [March 20, 2019, 4:00am UTC](https://discuss.elastic.co/t/filter-greater-than-in-table-visualization/173070 "2019-03-20T04:00:36Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![\_Levi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/_levi/32/34062_2.png) [@\_Levi](https://discuss.elastic.co/u/_Levi)
#### Post date: [March 20, 2019, 4:00am UTC](https://discuss.elastic.co/t/filter-greater-than-in-table-visualization/173070/1 "2019-03-20T04:00:36Z")

</div>

So here I have a table that has two columns Account Name and CountName where CountName is represent the number of Account Name, How can I filter to show the CountName greater than or equal 20 for examle. Here is my saved vis:  
`{ "title": "LeviTest", "type": "table", "params": { "perPage": 18, "showPartialRows": false, "showMetricsAtAllLevels": false, "sort": { "columnIndex": null, "direction": null }, "showTotal": true, "totalFunc": "sum" }, "aggs": [{ "id": "1", "enabled": true, "type": "count", "schema": "metric", "params": { "customLabel": "CountName" } }, { "id": "2", "enabled": true, "type": "terms", "schema": "bucket", "params": { "field": "AccountForWhichLogonFailed.AccountName.keyword", "size": 30, "order": "desc", "orderBy": "1", "otherBucket": false, "otherBucketLabel": "Other", "missingBucket": false, "missingBucketLabel": "Missing", "exclude": ".*[$]", "json": "", "customLabel": "Account Name" } } ] }`

---

<div class="post-metadata">

### Author: ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)
#### Post date: [March 20, 2019, 3:13pm UTC](https://discuss.elastic.co/t/filter-greater-than-in-table-visualization/173070/2 "2019-03-20T15:13:48Z")

</div>

Sounds like you're wanting to filter on an aggregated value (count)... Is that correct? Unfortunately there isn't any way to accomplish this at the moment.

---

<div class="post-metadata">

### Author: ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)
#### Post date: [March 20, 2019, 3:14pm UTC](https://discuss.elastic.co/t/filter-greater-than-in-table-visualization/173070/3 "2019-03-20T15:14:33Z")

</div>

Using Canvas inside Kibana you could accomplish this, however.

---

<div class="post-metadata">

### Author: ![\_Levi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/_levi/32/34062_2.png) [@\_Levi](https://discuss.elastic.co/u/_Levi)
#### Post date: [March 21, 2019, 3:43am UTC](https://discuss.elastic.co/t/filter-greater-than-in-table-visualization/173070/4 "2019-03-21T03:43:19Z")

</div>

Hmm I see, thanks Lukas for the info 🙂

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 18, 2019, 3:43am UTC](https://discuss.elastic.co/t/filter-greater-than-in-table-visualization/173070/5 "2019-04-18T03:43:27Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
