# Kibana filter query in visualization

**URL:** <https://discuss.elastic.co/t/kibana-filter-query-in-visualization/31959>\
**Category:** Kibana\
**Created:** [October 10, 2015, 7:15pm UTC](https://discuss.elastic.co/t/kibana-filter-query-in-visualization/31959 "2015-10-10T19:15:17Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![bubu.senapati](https://avatars.discourse-cdn.com/v4/letter/b/45deac/32.png) [@bubu.senapati](https://discuss.elastic.co/u/bubu.senapati)\
**Post date:** [October 10, 2015, 7:15pm UTC](https://discuss.elastic.co/t/kibana-filter-query-in-visualization/31959/1 "2015-10-10T19:15:17Z")

</div>

i want to execute a query in filter from kibana visualization.  
My requirement is as follows.  
I am getting response code from apachelog.  
I want to draw lines for response code-200  
and response code not equal to 200.  
How can i achieve it in same visualization

---

<div class="post-metadata">

**Author:** ![eperry](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/eperry/32/551_2.png) [@eperry](https://discuss.elastic.co/u/eperry)\
**Post date:** [October 11, 2015, 4:51pm UTC](https://discuss.elastic.co/t/kibana-filter-query-in-visualization/31959/2 "2015-10-11T16:51:05Z")

</div>

Generally I just do a visualization on all term for HTTP Status code

y Axis = count  
x axis = Date histogram  
X axis split line = term -\> response code

This would display each Response code over a Date histogram making a nice chart.

---

<div class="post-metadata">

**Author:** ![bubu.senapati](https://avatars.discourse-cdn.com/v4/letter/b/45deac/32.png) [@bubu.senapati](https://discuss.elastic.co/u/bubu.senapati)\
**Post date:** [October 11, 2015, 5:17pm UTC](https://discuss.elastic.co/t/kibana-filter-query-in-visualization/31959/3 "2015-10-11T17:17:27Z")

</div>

my require ment was only two lines.  
one for 200 and one for non 200(404,500 etc and all).  
anyways got it done

---

<div class="post-metadata">

**Author:** ![raamee](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/raamee/32/5110_2.png) [@raamee](https://discuss.elastic.co/u/raamee)\
**Post date:** [October 11, 2015, 5:20pm UTC](https://discuss.elastic.co/t/kibana-filter-query-in-visualization/31959/4 "2015-10-11T17:20:07Z")

</div>

Can you please share the way you did to achieve it?

---

<div class="post-metadata">

**Author:** ![bubu.senapati](https://avatars.discourse-cdn.com/v4/letter/b/45deac/32.png) [@bubu.senapati](https://discuss.elastic.co/u/bubu.senapati)\
**Post date:** [October 11, 2015, 5:21pm UTC](https://discuss.elastic.co/t/kibana-filter-query-in-visualization/31959/5 "2015-10-11T17:21:38Z")

</div>

do filter subaggregation  
respcode:200  
another filter  
-respcode:200

---

<div class="post-metadata">

**Author:** ![raamee](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/raamee/32/5110_2.png) [@raamee](https://discuss.elastic.co/u/raamee)\
**Post date:** [October 11, 2015, 5:28pm UTC](https://discuss.elastic.co/t/kibana-filter-query-in-visualization/31959/6 "2015-10-11T17:28:41Z")

</div>

Excellent. 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:11pm UTC](https://discuss.elastic.co/t/kibana-filter-query-in-visualization/31959/7 "2017-07-06T14:11:33Z")

</div>