# Filter kibana charts based on field values

**URL:** https://discuss.elastic.co/t/filter-kibana-charts-based-on-field-values/819
**Category:** Kibana
**Created:** [May 18, 2015, 5:27am UTC](https://discuss.elastic.co/t/filter-kibana-charts-based-on-field-values/819 "2015-05-18T05:27:08Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![sunilactivity](https://avatars.discourse-cdn.com/v4/letter/s/f14d63/32.png) [@sunilactivity](https://discuss.elastic.co/u/sunilactivity)
#### Post date: [May 18, 2015, 5:27am UTC](https://discuss.elastic.co/t/filter-kibana-charts-based-on-field-values/819/1 "2015-05-18T05:27:08Z")

</div>

I am using kibana 4.0 and elastic search 1.5  
I want to exclude a certain set of documents from appearing in my chart if it has a particular field set.

eg. This is my set of document.

{"Name": "windows2008", "Domain":"xyz", "IsLatest": "Yes" }  
{"Name": "windows2008 R2", "Domain":"xyz", "IsLatest": "Yes" }  
{"Name": "windows2008 R2", "Domain":"abc", "IsLatest": "No" }  
{"Name": "windows2003", "Domain":"pqr", "IsLatest": "No" }

I want to plot only the documents which has the field "IsLatest" set to Yes.

Is it possible to do in kibana 4.0?

Thanks & Regards  
Sunil

---

<div class="post-metadata">

### Author: ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [May 18, 2015, 5:59am UTC](https://discuss.elastic.co/t/filter-kibana-charts-based-on-field-values/819/2 "2015-05-18T05:59:50Z")

</div>

In discover mode, you can create a query that filters out the events that does not have "IsLatest" set to "Yes" and then save this. When you build your visualisation, you should be able to base it on this filtered query instead of the unfiltered one to get the result you are looking for.

Best regards,

Christian

---

<div class="post-metadata">

### Author: ![sunilactivity](https://avatars.discourse-cdn.com/v4/letter/s/f14d63/32.png) [@sunilactivity](https://discuss.elastic.co/u/sunilactivity)
#### Post date: [May 18, 2015, 8:35am UTC](https://discuss.elastic.co/t/filter-kibana-charts-based-on-field-values/819/3 "2015-05-18T08:35:02Z")

</div>

Can you please guide me with a sample query?

I am new to elasticsearch and kibana and am slowly understand the concepts.  
I appreciate your help.

---

<div class="post-metadata">

### Author: ![ChrisMark](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/chrismark/32/400_2.png) [@ChrisMark](https://discuss.elastic.co/u/ChrisMark)
#### Post date: [May 18, 2015, 9:09am UTC](https://discuss.elastic.co/t/filter-kibana-charts-based-on-field-values/819/4 "2015-05-18T09:09:03Z")

</div>

Hello,

in discover tab you can do this querry-search : **\_IsLatest=Yes**  
Then you will see that this brings you all the docs that have IsLatest field equal to "Yes".

If you want to plot (count plot for example) these docs you can use the same search in visualize tab.  
😉

---

<div class="post-metadata">

### Author: ![sunilactivity](https://avatars.discourse-cdn.com/v4/letter/s/f14d63/32.png) [@sunilactivity](https://discuss.elastic.co/u/sunilactivity)
#### Post date: [May 18, 2015, 9:27am UTC](https://discuss.elastic.co/t/filter-kibana-charts-based-on-field-values/819/5 "2015-05-18T09:27:05Z")

</div>

thank you.. 😃

---

<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: [July 6, 2017, 2:19pm UTC](https://discuss.elastic.co/t/filter-kibana-charts-based-on-field-values/819/6 "2017-07-06T14:19:23Z")

</div>


