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

(R Heng) #1

(R Heng) #2

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

(Shaunak Kashyap) #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

(R Heng) #4

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

(R Heng) #5

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

(system) #6