Get most recent hit by some field on Discover

[liorh (lior hen)]

Hi
Attached is a screenshot of my Discover. How can I make it to show me only the most recent row per event.transactionId? I marked those rows.

Thank you very much

[stephenb (Stephen Brown)]

Discover will not do that.

You should look at the Latest transform... Exactly what you are looking for.

Transform overview | Elasticsearch Guide [8.5] | Elastic

[liorh (lior hen)]

Thank you very much.