# Select last value in Data Table

**URL:** <https://discuss.elastic.co/t/select-last-value-in-data-table/196063>\
**Category:** Kibana\
**Created:** [August 21, 2019, 8:27am UTC](https://discuss.elastic.co/t/select-last-value-in-data-table/196063 "2019-08-21T08:27:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![luc1](https://avatars.discourse-cdn.com/v4/letter/l/e79b87/32.png) [@luc1](https://discuss.elastic.co/u/luc1)\
**Post date:** [August 21, 2019, 8:27am UTC](https://discuss.elastic.co/t/select-last-value-in-data-table/196063/1 "2019-08-21T08:27:27Z")

</div>

Hi, I'm trying to display only the last "alarms" of my server in a data table.  
So I did the following thing

 ![Screenshot%20(31)](https://us1.discourse-cdn.com/elastic/original/3X/e/2/e25bceb47721d895950d18a586bc9888a467e8f4.png)

(Sort on Time)  
I display several fields

 ![Screenshot%20(34)](https://us1.discourse-cdn.com/elastic/original/3X/2/9/29836c89d9483c06da905ee8468476e44f42dd0a.png)

But as shown here :  
 ![Screenshot%20(36)](https://us1.discourse-cdn.com/elastic/original/3X/c/8/c8eda646d459b5e407ccade022c477cd2f3a7ff6.png)

It shows me the last time an alarm was seen but not the actual LAST alarms (which should be all at 18h03)

Is there a way to do it ? Maybe with a SQL filter but I don't know how it works on Kibana. Thanks in advance if you have any tip !

---

<div class="post-metadata">

**Author:** ![nickpeihl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nickpeihl/32/112622_2.png) [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)\
**Post date:** [August 22, 2019, 6:23pm UTC](https://discuss.elastic.co/t/select-last-value-in-data-table/196063/2 "2019-08-22T18:23:04Z")

</div>

You may want to create a saved search in Discover instead. You can select which columns to display and sort by the time field in descending order. You can also add a Saved Search to a Dashboard.

[https://www.elastic.co/guide/en/kibana/7.3/document-data.html](https://www.elastic.co/guide/en/kibana/7.3/document-data.html)

---

<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:** [September 19, 2019, 6:23pm UTC](https://discuss.elastic.co/t/select-last-value-in-data-table/196063/3 "2019-09-19T18:23:09Z")

</div>

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