# Min and Max condition in Kibana

**URL:** <https://discuss.elastic.co/t/min-and-max-condition-in-kibana/64860>\
**Category:** Kibana\
**Created:** [November 3, 2016, 12:38pm UTC](https://discuss.elastic.co/t/min-and-max-condition-in-kibana/64860 "2016-11-03T12:38:27Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![gayathri](https://avatars.discourse-cdn.com/v4/letter/g/838e76/32.png) [@gayathri](https://discuss.elastic.co/u/gayathri)\
**Post date:** [November 3, 2016, 12:38pm UTC](https://discuss.elastic.co/t/min-and-max-condition-in-kibana/64860/1 "2016-11-03T12:38:27Z")

</div>

Hi Team,

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

---

<div class="post-metadata">

**Author:** ![jbudz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jbudz/32/45922_2.png) [@jbudz](https://discuss.elastic.co/u/jbudz)\
**Post date:** [November 3, 2016, 4:39pm UTC](https://discuss.elastic.co/t/min-and-max-condition-in-kibana/64860/2 "2016-11-03T16:39:48Z")

</div>

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](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-query-string-query.html#_ranges) for more info.

---

<div class="post-metadata">

**Author:** ![gayathri](https://avatars.discourse-cdn.com/v4/letter/g/838e76/32.png) [@gayathri](https://discuss.elastic.co/u/gayathri)\
**Post date:** [November 4, 2016, 9:49am UTC](https://discuss.elastic.co/t/min-and-max-condition-in-kibana/64860/3 "2016-11-04T09:49:34Z")

</div>

Hi Jon,

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

---

<div class="post-metadata">

**Author:** ![jbudz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jbudz/32/45922_2.png) [@jbudz](https://discuss.elastic.co/u/jbudz)\
**Post date:** [November 4, 2016, 5:31pm UTC](https://discuss.elastic.co/t/min-and-max-condition-in-kibana/64860/4 "2016-11-04T17:31:11Z")

</div>

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

 ![](https://us1.discourse-cdn.com/elastic/original/2X/5/55722fad7015264da50f3f60ee0f2979213962e2.png)  
Then there's a sort icon on the column:  
 ![](https://us1.discourse-cdn.com/elastic/original/2X/2/283b3970522cd348c375b7f2eeb5dfbdca94b301.png)

---

<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:34pm UTC](https://discuss.elastic.co/t/min-and-max-condition-in-kibana/64860/5 "2017-07-06T13:34:30Z")

</div>