Currently trying to get the most recent value of a transactiondurationtime. I got a data table with the
name of transaction, average transaction duration, recent transaction duration (which I need to have/calculate)
I only get the options such as average, count, max, min but not recent. There is an advanced option for a JSON input but I cannot find a way to get this working. The field name is transactionduration.
Hi @Negan Welcome to the community.
What version are you on?
Can you give some samples of your data and what you want for the expected results?
testname.keyword, transactionduration (average)
And now I want for each test1, test2, test3 the most recent transactionduration in milliseconds.
more than this I cannot give away for data.
in Aggregation-based visualisation (the one you show) you can use a "top metric" aggregation on the field you want (transactionduration) sorted by timestamp descending. It does what you need.
You can also (even easier) do the visualization in Lens, there is a Last Value function for that.