Filter index to get the field max value

[Liam619 (William Low)]

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.

Best regards
William

[bhavyarm]

Hello,

Which visualization are you trying to build to display this?

Thanks,
Bhavya

[Liam619 (William Low)]

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