Filter last result in Kibana table

[artobstrel (Bogdan)]

I have the following data:

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

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

Samples under the spoiler

This is right:

This is wrong:

[corey.robertson]

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?

[artobstrel (Bogdan)]

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