# Filter results in visualtion

**URL:** https://discuss.elastic.co/t/filter-results-in-visualtion/155755
**Category:** Kibana
**Created:** [November 7, 2018, 4:09pm UTC](https://discuss.elastic.co/t/filter-results-in-visualtion/155755 "2018-11-07T16:09:26Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Ritesh\_Uniyal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ritesh_uniyal/32/43678_2.png) [@Ritesh\_Uniyal](https://discuss.elastic.co/u/Ritesh_Uniyal)
#### Post date: [November 7, 2018, 4:09pm UTC](https://discuss.elastic.co/t/filter-results-in-visualtion/155755/1 "2018-11-07T16:09:27Z")

</div>

Hi,  
I have a visualization of DataTable where I have a Metric of Count. Now i get lot of records where Count ranges from 1 to 500 and I only want to see where Count is more than 100. How can i achieve this.

Thanks

---

<div class="post-metadata">

### Author: ![jen-huang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jen-huang/32/74327_2.png) [@jen-huang](https://discuss.elastic.co/u/jen-huang)
#### Post date: [November 9, 2018, 9:03pm UTC](https://discuss.elastic.co/t/filter-results-in-visualtion/155755/2 "2018-11-09T21:03:49Z")

</div>

Hello, you can do this by sending `min_doc_count` with your bucket aggregation using the **JSON Input** field. In this example I am filtering my buckets to ones that have a minimum of 3 documents:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/d/e/de0d669b6c40c0084b67b8483838586f09d27988.png)

---

<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: [December 7, 2018, 9:03pm UTC](https://discuss.elastic.co/t/filter-results-in-visualtion/155755/3 "2018-12-07T21:03:50Z")

</div>

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