Date first occurrence of latest value

Elastic Stack Kibana
1

Hello, i like to have the date of the first occurence of the latest value.
Is this possible?

I can use the latest value in metric but i like to have the date of the first occurence of this latest value

2

Thanks for reaching out, @apenootje. You could first identify the max value using a Max aggregation in a Metric visualization to find the highest or most recent value. From there, you can create a data table or visualization for the first occurrence and add both visualizations to a single dashboard.

If this method doesn't work for you, I'd be interested in learning more about the context of what you are looking to accomplish and what you are expecting to see.

3

thx for the reply, want i now have is something like this in the logging:

environment, releasenumber,date
prd, 1.0.2,aug 27 @ 13:08:00.001
prd, 1.0.2,aug 25 @ 13:07:00.001
prd, 1.0.2,aug 24 @ 13:05:00.001
prd, 1.0.1,aug 23 @ 13:04:00.001
prd, 1.0.1,aug 22 @ 13:02:00.001
prd, 1.0.1,aug 22 @ 13:00:00.001

what i would like to see here is the latest value of releasenumber, in this case it is 1.0.2 and then also the date when it occured the first time, in this case aug 24 @ 13:05:00.001.
I now have a lens metric where i can filter on the latest value, that is working but i would like to add the date of it to the dashboard, how can i do this?

4

Thanks for following up, @apenootje.

You could use the Min aggregation on the date field to find the earliest occurrence. Additionally, you could bucket aggregation, typically a terms aggregation on the release number field. Make sure to sort the release number field in descending order and limit the size to 1 only to show the latest release number.