Filter index to get the field max value

Elastic Stack Kibana
1

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
sample1566×280 18.5 KB

Best regards
William

2

Hello,

Which visualization are you trying to build to display this?

Thanks,
Bhavya

3

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