Only show most current docs in Dashboard or Visualization

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

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

1 Like

You can use a TSVB visualization.

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

image

1 Like

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

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