KQL Max query search

Elastic Stack Kibana
1

Hello,

I need to figure out a KQL query to pick a max value. My data is like below
Doc1 => AppName: "A" , Revision : 1 then other keys
Doc2 => AppName: "A" , Revision : 2
*
*
Docn => AppName: "A" , Revision : n.

Revision is integer

Here Revision will grow. I need to pick only the max Revision doc using a KQL query (Result should be one record that should have the max Revision number only). I need to use That value in Visualization. Thanks.

2

KQL is not the right tool to accomplish this task. However, you might be able to accomplish this by using the Max aggregation.

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.