How to calculate the timestamp difference between two actions?

Elastic Stack Kibana
1

Hello,
I'd like to calculate the timestamp difference between two actions.
But I can't find a way to do it.

Log example is below.

@timestamp action
May 20th 2018, 15:41:32.111 login
May 21th 2018, 10:39:01.761 logout

Please guide.

Thank you.
maedamaeda

2

What do your Elasticsearch indices and docs look like? Is the log example data in one document, or multiple documents?

3

My Elasticsearch indices web application logs.
The logs are in multiple documents.

4

I recommend restructuring the data sent to Elasticsearch so that each document looks something like this:

{
  "session_id": 123456,
  "login_time": "May 20th 2018, 15:41:32.111",
  "logout_time": "May 21th 2018, 10:39:01.761",
}

Then, you can add a Scripted field in Kibana to calculate the difference between login_time and logout_time.

You can read more about modeling data for Elasticsearch here.

4 Likes
5

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.