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

(Prudhvi Chowdhary Nekkalapudi) #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

(Bhavya R M) #2

Yep. You can definitely use scripted fields for it.

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

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

Thanks,
Bhavya

(Prudhvi Chowdhary Nekkalapudi) #3

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

(Bhavya R M) #4

Hello,

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

Thanks,
Bhavya

(system) closed #5

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