How to calculate difference of two dates and display the result in seconds(integer type) through scripted fields in kibana

Elastic Stack Kibana
1

I have two dates in a index

t1 : February 12th 2019, 11:54:48.000

t2 : February 12th 2019, 11:56:10.000

the result t2-t1=execution time(in my case).Now how to calculate t2-t1 and display result in seconds .Here execution time should be of integer type.this should be done in scripted fields in kibana .Help me out

2

Yep. You can definitely use scripted fields for it.

Here is an example where we are extracting hour of the day:

54%20PM
Screen Shot 2019-02-18 at 6.43.54 PM.png2880×1800 1.07 MB

https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-script-fields.html

Thanks,
Bhavya

3

can we run kibana v 6.6.0 with elastic search v6.0.1

4

Hello,

Unfortunately that is not possible:
https://www.elastic.co/support/matrix#matrix_compatibility

Thanks,
Bhavya

5

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