Filter last result in Kibana table

Elastic Stack Kibana
1

I have the following data:

image

With "Top Hit" aggregations I can get the latest result of each event:

image

How can I filter Data Table results to get events with the last result is "failed"?

Samples under the spoiler

This is right: :slightly_smiling_face:

image
image747×66 3.4 KB

This is wrong: :frowning_face:

image
image753×99 4.81 KB

2

Hi @artobstrel

Are you using Visualize to create these visualizations, or are you asking what raw elasticsearch query you can use to get the results you are looking for?

3

I asked about solution. The goal is data table visualization.

4

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