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

Elastic Stack Kibana
1

test1.jpg1240×814 104 KB

2

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

3

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

4

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

5

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