Calculating elapsed time between two timestamps

Grafana Stat Panel
1

  • What Grafana version and what operating system are you using?

  • What are you trying to achieve?

I am trying to calculate the elapsed time between the most recent time stamp and the second most recent time stamp to find the time it took between two events.

  • How are you trying to achieve it?

Currently, I am only able to see a log several most recent time stamps and don’t see a clear way to create the calculation desired. I am pulling in the data, running a “filter by name” transform to pull only the @timestamp, the inputting it as a custom “time: hh:mm:ss” unit to show this panel.

image
image943×298 8.87 KB

  • Can you copy/paste the configuration(s) that you are having problems with?
    The data is all based off of the timestamps of events as shown below
    image
    image754×460 9.2 KB
2

what is your datasource?

3

The datasource I am using is an Elasticsearch ZEUS that is pulling in completion of events from another source. The timestamp of the event is the only relevant part of that event though.

1 Like
4

I would recommend using infinity plugin to be able to leverage jsonata to do what you want