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