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

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?

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

Filter last result in Kibana table

Elastic Stack Kibana

artobstrel (Bogdan) April 13, 2021, 10:50am 1

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:

Topic		Replies	Views
Kibana data table with TopHit aggregation Kibana	3	455	January 23, 2020
Making filter for the last data set in Kibana discover Elasticsearch	6	1151	June 24, 2019
How to get Data Table Visualization with Top Hit show the last result for the bucket? Kibana	5	1856	March 18, 2021
Kibana data table with the aggregations only on the latest records Kibana	3	1297	February 4, 2019
Datatable with only the last results on a certain term? Kibana	2	461	April 10, 2020

Filter last result in Kibana table

Related topics