# Kibana - how to exclude value 0 from table

**URL:** https://discuss.elastic.co/t/kibana-how-to-exclude-value-0-from-table/191158
**Category:** Kibana
**Created:** [July 18, 2019, 8:34am UTC](https://discuss.elastic.co/t/kibana-how-to-exclude-value-0-from-table/191158 "2019-07-18T08:34:45Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![nickseda](https://avatars.discourse-cdn.com/v4/letter/n/d9b06d/32.png) [@nickseda](https://discuss.elastic.co/u/nickseda)
#### Post date: [July 18, 2019, 8:34am UTC](https://discuss.elastic.co/t/kibana-how-to-exclude-value-0-from-table/191158/1 "2019-07-18T08:34:45Z")

</div>

Hi,

I am on kibana 7.0.1.  
What do I need to enter in the json part, if I want to exclude value o in table as below?

 ![1](https://us1.discourse-cdn.com/elastic/original/3X/7/0/701ad4faa896817fcd4bbdf83cf30aa691a94745.jpeg)

Do I need to enable scripting in elasticsearch? How?

Thanks

---

<div class="post-metadata">

### Author: ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [July 18, 2019, 5:06pm UTC](https://discuss.elastic.co/t/kibana-how-to-exclude-value-0-from-table/191158/2 "2019-07-18T17:06:13Z")

</div>

Just mouseover the 0 value and 2 magnifying glasses with a + and a - should appear. Click on the one with 0 if you want to exclude the 0 values.

---

<div class="post-metadata">

### Author: ![nickseda](https://avatars.discourse-cdn.com/v4/letter/n/d9b06d/32.png) [@nickseda](https://discuss.elastic.co/u/nickseda)
#### Post date: [July 19, 2019, 4:46am UTC](https://discuss.elastic.co/t/kibana-how-to-exclude-value-0-from-table/191158/3 "2019-07-19T04:46:48Z")

</div>

Thanks bro for the answer. But that was not what my question means.

Ref the attached table, how to display only data with number except the name with 0 value from column W/o\_Entry ?

I'm in the midst to create the table displaying only names with value (don't want names with 0 entry).

Thanks for help. I'm new guy with kibana tho.

---

<div class="post-metadata">

### Author: ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [July 19, 2019, 4:14pm UTC](https://discuss.elastic.co/t/kibana-how-to-exclude-value-0-from-table/191158/4 "2019-07-19T16:14:06Z")

</div>

Just enter in the filter bar in the top: `not W/o_Entry : 0` and this will do what you want. No need to change the JSON by hand as the filter does this for you.

---

<div class="post-metadata">

### Author: ![nickseda](https://avatars.discourse-cdn.com/v4/letter/n/d9b06d/32.png) [@nickseda](https://discuss.elastic.co/u/nickseda)
#### Post date: [July 22, 2019, 12:53am UTC](https://discuss.elastic.co/t/kibana-how-to-exclude-value-0-from-table/191158/5 "2019-07-22T00:53:44Z")

</div>

Thanks bro.

---

<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: [August 19, 2019, 12:53am UTC](https://discuss.elastic.co/t/kibana-how-to-exclude-value-0-from-table/191158/6 "2019-08-19T00:53:54Z")

</div>

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