Hi i am trying to calculate time difference between two fields: netflow.first_switched Sep 2, 2019 @ 16:25:51.000 netflow.last_switched Sep 2, 2019 @ 16:25:52.182 I am using: doc['netflow.last_switched'].value-doc['netflow.first_switched'].value but I am not getting any value while previewing…

Trying to calculate time difference using scripted fields

matw (Matthias Wilhelm) September 4, 2019, 8:08am 5

please try the following

doc['netflow.last_switched'].value.millis - doc['netflow.first_switched'].value.millis

Painless script to calculate elapsed time between two fields

Topic		Replies	Views
Painless script to calculate elapsed time between two fields Kibana	14	1439	July 8, 2021
Datefields time difference in scripted field produce zero always Kibana	2	319	February 28, 2019
Painless script to get date difference Kibana painless	3	3538	April 10, 2020
Calculate Time Difference in Kibana Kibana	3	3173	February 28, 2019
Scripted Fields Date Math Kibana	16	7477	December 27, 2018