# \[SOLVED\] Is there a way to exclude 0 size (kibana 4.5.1)

**URL:** <https://discuss.elastic.co/t/solved-is-there-a-way-to-exclude-0-size-kibana-4-5-1/52137>\
**Category:** Kibana\
**Created:** [June 8, 2016, 12:31am UTC](https://discuss.elastic.co/t/solved-is-there-a-way-to-exclude-0-size-kibana-4-5-1/52137 "2016-06-08T00:31:09Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![rheng](https://avatars.discourse-cdn.com/v4/letter/r/ccd318/32.png) [@rheng](https://discuss.elastic.co/u/rheng)\
**Post date:** [June 8, 2016, 12:31am UTC](https://discuss.elastic.co/t/solved-is-there-a-way-to-exclude-0-size-kibana-4-5-1/52137/1 "2016-06-08T00:31:09Z")

</div>

![](https://us1.discourse-cdn.com/elastic/original/2X/d/dfe6c0a94c35df783dff115378e8cdc74d058351.jpg)

---

<div class="post-metadata">

**Author:** ![rheng](https://avatars.discourse-cdn.com/v4/letter/r/ccd318/32.png) [@rheng](https://discuss.elastic.co/u/rheng)\
**Post date:** [June 8, 2016, 12:32am UTC](https://discuss.elastic.co/t/solved-is-there-a-way-to-exclude-0-size-kibana-4-5-1/52137/2 "2016-06-08T00:32:30Z")

</div>

I'd like to keep the columns the way they are, but exclude all the file name with size 0.

---

<div class="post-metadata">

**Author:** ![shaunak](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/shaunak/32/6643_2.png) [@shaunak](https://discuss.elastic.co/u/shaunak)\
**Post date:** [June 8, 2016, 12:55am UTC](https://discuss.elastic.co/t/solved-is-there-a-way-to-exclude-0-size-kibana-4-5-1/52137/3 "2016-06-08T00:55:35Z")

</div>

Yes, try entering this in the search bar above the visualization editor (where it currently has `*` in it):

`{ "range": { "file_meta.file_size": { "gt": 0 } } }`

This performs an Elasticsearch range query. You can read more about it over here: [https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-range-query.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-range-query.html)

---

<div class="post-metadata">

**Author:** ![rheng](https://avatars.discourse-cdn.com/v4/letter/r/ccd318/32.png) [@rheng](https://discuss.elastic.co/u/rheng)\
**Post date:** [June 8, 2016, 1:53am UTC](https://discuss.elastic.co/t/solved-is-there-a-way-to-exclude-0-size-kibana-4-5-1/52137/4 "2016-06-08T01:53:58Z")

</div>

> [@shaunak](#):
>
> { "range": { "file\_meta.file\_size": { "gt": 0 } } }

Thank you. Is there a way to include that query in the aggregation? (meaning without having to enter that in the search bar?

---

<div class="post-metadata">

**Author:** ![rheng](https://avatars.discourse-cdn.com/v4/letter/r/ccd318/32.png) [@rheng](https://discuss.elastic.co/u/rheng)\
**Post date:** [June 8, 2016, 3:20am UTC](https://discuss.elastic.co/t/solved-is-there-a-way-to-exclude-0-size-kibana-4-5-1/52137/5 "2016-06-08T03:20:49Z")

</div>

Ah..i figured it out..i can build the visualization based on the saved search using the range you provided above.

---

<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, 1:51pm UTC](https://discuss.elastic.co/t/solved-is-there-a-way-to-exclude-0-size-kibana-4-5-1/52137/6 "2017-07-06T13:51:13Z")

</div>

Closed on July 6, 2017, 1:51pm UTC