# Only show most current docs in Dashboard or Visualization

**URL:** <https://discuss.elastic.co/t/only-show-most-current-docs-in-dashboard-or-visualization/230785>\
**Category:** Elasticsearch\
**Created:** [May 2, 2020, 1:56am UTC](https://discuss.elastic.co/t/only-show-most-current-docs-in-dashboard-or-visualization/230785 "2020-05-02T01:56:35Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![cglencr](https://avatars.discourse-cdn.com/v4/letter/c/db5fbb/32.png) [@cglencr](https://discuss.elastic.co/u/cglencr)\
**Post date:** [May 2, 2020, 1:56am UTC](https://discuss.elastic.co/t/only-show-most-current-docs-in-dashboard-or-visualization/230785/1 "2020-05-02T01:56:35Z")

</div>

Here is an example of what I would like to do in Elastic

Every 10 minutes temperatures from cities are sent to an Elastic index: citytemps

**Citytemps index**  
Index \_id CityID CityName TemperatureDate Temperature  
jkskhj2ks8f 1 Halifax 2020-04-29 08:00 4  
isdnvl398hsa 2 Toronto 2020-04-29 08:00 7  
abcj3k45o5j 3 Calgary 2020-04-29 08:00 -2  
kdnj94nadfk 1 Halifax 2020-04-29 08:10 5  
jkdsjk489dn 2 Toronto 2020-04-29 08:10 7  
ksdnsdk4ia7 3 Calgary 2020-04-29 08:10 0  
iwdkxcnkl79 1 Halifax 2020-04-29 08:20 8  
ksvkd7as823 2 Toronto 2020-04-29 08:20 9

I would like to show a table or grid of the most recent temperatures only.  
Is that a Index Pattern or Search or Query or Dashboard or Visualization?

Most current temperatures  
CityID CityName TemperatureDate Temperature  
1 Halifax 2020-04-29 08:20 8  
2 Toronto 2020-04-29 08:20 9  
3 Calgary 2020-04-29 08:10 0

How can I achieve this? Thanks

---

<div class="post-metadata">

**Author:** ![KoettingSimon](https://avatars.discourse-cdn.com/v4/letter/k/ba9def/32.png) [@KoettingSimon](https://discuss.elastic.co/u/KoettingSimon)\
**Post date:** [May 2, 2020, 7:43pm UTC](https://discuss.elastic.co/t/only-show-most-current-docs-in-dashboard-or-visualization/230785/2 "2020-05-02T19:43:44Z")

</div>

Hi Craig,  
Yes, this is possible with an metric visualisation which you can add to an dashboard if you want.  
Have a look at this thread:

> [@Display latest value in a „Metric“](https://discuss.elastic.co/t/display-latest-value-in-a-metric/114930/2):
>
> I just wrote this 1 minute ago in another topic. Seems to be the popular question of the day: Metric Aggregation: Top Hit Field: your\_field Aggregate with: concatenate Size: 1 Sort on: @timestamp Order: Descending

Regards,  
Simon

---

<div class="post-metadata">

**Author:** ![Luca\_Belluccini](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/luca_belluccini/32/33239_2.png) [@Luca\_Belluccini](https://discuss.elastic.co/u/Luca_Belluccini)\
**Post date:** [May 2, 2020, 11:44pm UTC](https://discuss.elastic.co/t/only-show-most-current-docs-in-dashboard-or-visualization/230785/3 "2020-05-02T23:44:37Z")

</div>

You can use a TSVB visualization.

Select the `Table` TSVB visualization and in the `Panel options` select `Last value`.

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

---

<div class="post-metadata">

**Author:** ![cglencr](https://avatars.discourse-cdn.com/v4/letter/c/db5fbb/32.png) [@cglencr](https://discuss.elastic.co/u/cglencr)\
**Post date:** [May 19, 2020, 11:46pm UTC](https://discuss.elastic.co/t/only-show-most-current-docs-in-dashboard-or-visualization/230785/4 "2020-05-19T23:46:31Z")

</div>

When you add new labels how do you select fields that are not numeric?

---

<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:** [June 16, 2020, 11:46pm UTC](https://discuss.elastic.co/t/only-show-most-current-docs-in-dashboard-or-visualization/230785/5 "2020-06-16T23:46:35Z")

</div>

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