# Datatable with only the last results on a certain term?

**URL:** https://discuss.elastic.co/t/datatable-with-only-the-last-results-on-a-certain-term/223486
**Category:** Kibana
**Created:** [March 13, 2020, 10:08am UTC](https://discuss.elastic.co/t/datatable-with-only-the-last-results-on-a-certain-term/223486 "2020-03-13T10:08:28Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)
#### Post date: [March 13, 2020, 12:54pm UTC](https://discuss.elastic.co/t/datatable-with-only-the-last-results-on-a-certain-term/223486/2 "2020-03-13T12:54:02Z")

</div>

This is the way to do it. Only difference is that you should use the Date field instead of the @timestamp, judging by your screenshot there.

> [@Display latest value in a „Metric“](https://discuss.elastic.co/t/display-latest-value-in-a-metric/114930):
>
> Hi there, I would like to display the latest value of a given index in a dashboard with a „Metric“. This should happen in a aws instance of Kibana. Is it possible to do this? The aggregation of the metric inside „Metric“ only shows me stuff like „Count“, „Average“ or „Sum“ but not „Latest“. I wonder if this is possible with the Metric visualisation.

---

_[View the full topic](https://discuss.elastic.co/t/datatable-with-only-the-last-results-on-a-certain-term/223486)._