Min and Max condition in Kibana

Elastic Stack Kibana
1

Hi Team,

Could you please let me know the query for printing the logs which have min field value in discov
er.

2

In the search bar:

range:
my_field:[100 TO 2000]

min:
my_field:[100 to *]

max:
my_field:[* to 100]

https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-query-string-query.html#_ranges for more info.

3

Hi Jon,

I want to select the log which has min value of certain field.

4

Ah, okay. On the sidebar, find your field and when you hover over it a button will show, click add:

Pasted image320×677 16.7 KB

Then there's a sort icon on the column: