Min and Max timestamp difference

SUBIN_B_MATHEW · May 30, 2023, 5:36am

Aggregated the Min and Max timestamp based on the message id. I wanted to calculate the time difference between min and Max time and show it in a data table on kibana dashboard , could you please help me on this?

Marta_Bondyra · June 20, 2023, 8:04am

Hello, welcome to the community and apologies for the late answer.
You could use Lens and formula to achieve it. Here's the example:

Topic		Replies	Views
Difference between Max timestamp and Minimum timstamp in kibana Kibana	4	1100	June 6, 2017
How to get difference of min timestamp and max timestamp? Kibana	3	2326	October 15, 2019
How to get the difference between min timestamp and max timestamp? Kibana	2	1078	April 17, 2019
How to show timestamp difference between max and min in data table Elasticsearch	1	556	August 19, 2021
Calculate duration between min and max @timestamp Kibana	2	1538	August 31, 2017

Min and Max timestamp difference

Related topics