Datatable with only the last results on a certain term?

[Marco_Pas]

Hi there, i am trying to visualize a datatable that contains documents but i only want to display the latest rows per for example "project-code"..

Any hint on how to achieve this?

I tried to set a x-axis metric based on a 'top-hit' but this has no effect.
Any suggestions are appriciated!

[Marius_Dragomir]

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“

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.