Only show most current docs in Dashboard or Visualization

Elastic Stack Elasticsearch
1

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

2

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:

Regards,
Simon

3

You can use a TSVB visualization.

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

image

4

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