# Filter last result in Kibana table

**URL:** <https://discuss.elastic.co/t/filter-last-result-in-kibana-table/269995>\
**Category:** Kibana\
**Created:** [April 13, 2021, 10:50am UTC](https://discuss.elastic.co/t/filter-last-result-in-kibana-table/269995 "2021-04-13T10:50:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![artobstrel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/artobstrel/32/16874_2.png) [@artobstrel](https://discuss.elastic.co/u/artobstrel)\
**Post date:** [April 13, 2021, 10:50am UTC](https://discuss.elastic.co/t/filter-last-result-in-kibana-table/269995/1 "2021-04-13T10:50:03Z")

</div>

I have the following data:

![image](https://us1.discourse-cdn.com/elastic/original/3X/b/3/b3c3f48c937b7babdf45961d76d79ff76059ee92.png)

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

![image](https://us1.discourse-cdn.com/elastic/original/3X/f/2/f297316f8dadb0e46e13fc28a0bfbec5a21bbb9b.png)

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

> **Samples under the spoiler**
>
> **This is right:** 🙂
> 
> ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/9/a980e954ee86cafb697349c131ba4c50a6897168.png)
> 
> **This is wrong:** ☹
> 
> ![image](https://us1.discourse-cdn.com/elastic/original/3X/6/2/623b687b5f0ba93910e49ed4da2e3c3db3678685.png)

---

<div class="post-metadata">

**Author:** ![corey.robertson](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/corey.robertson/32/54611_2.png) [@corey.robertson](https://discuss.elastic.co/u/corey.robertson)\
**Post date:** [April 13, 2021, 4:32pm UTC](https://discuss.elastic.co/t/filter-last-result-in-kibana-table/269995/2 "2021-04-13T16:32:05Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![artobstrel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/artobstrel/32/16874_2.png) [@artobstrel](https://discuss.elastic.co/u/artobstrel)\
**Post date:** [April 14, 2021, 1:16pm UTC](https://discuss.elastic.co/t/filter-last-result-in-kibana-table/269995/3 "2021-04-14T13:16:06Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [May 12, 2021, 1:16pm UTC](https://discuss.elastic.co/t/filter-last-result-in-kibana-table/269995/4 "2021-05-12T13:16:55Z")

</div>

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