# Filter index to get the field max value

**URL:** <https://discuss.elastic.co/t/filter-index-to-get-the-field-max-value/363438>\
**Category:** Kibana\
**Created:** [July 19, 2024, 1:19pm UTC](https://discuss.elastic.co/t/filter-index-to-get-the-field-max-value/363438 "2024-07-19T13:19:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Liam619](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/liam619/32/129678_2.png) [@Liam619](https://discuss.elastic.co/u/Liam619)\
**Post date:** [July 19, 2024, 1:19pm UTC](https://discuss.elastic.co/t/filter-index-to-get-the-field-max-value/363438/1 "2024-07-19T13:19:21Z")

</div>

Hi everyone, I'm trying to filter my index to display based on the field max value. I searched around the internet but couldn't understand how to do it.

Currently running kibana 7.17.1

Below is the sample index, what I'm trying to do is filter max(dayEndNo) so that it will only display 51.

 ![sample](https://us1.discourse-cdn.com/elastic/original/3X/9/f/9f8745c52f955fe2e6518726eda52a65d52e9eee.png)

Best regards  
William

---

<div class="post-metadata">

**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\
**Post date:** [July 29, 2024, 9:11pm UTC](https://discuss.elastic.co/t/filter-index-to-get-the-field-max-value/363438/2 "2024-07-29T21:11:30Z")

</div>

Hello,

Which visualization are you trying to build to display this?

Thanks,  
Bhavya

---

<div class="post-metadata">

**Author:** ![Liam619](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/liam619/32/129678_2.png) [@Liam619](https://discuss.elastic.co/u/Liam619)\
**Post date:** [July 30, 2024, 1:53am UTC](https://discuss.elastic.co/t/filter-index-to-get-the-field-max-value/363438/3 "2024-07-30T01:53:02Z")

</div>

Hi Bhavya,

I'm trying to build it using Lens. I wish to filter out the indexing data to get the max(dayEndNo), so that I can easily display what I needed.

best regards  
William