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	1427	July 8, 2021
Datefields time difference in scripted field produce zero always Kibana	2	317	February 28, 2019
Painless script to get date difference Kibana painless	3	3515	April 10, 2020
Calculate Time Difference in Kibana Kibana	3	3167	February 28, 2019
Scripted Fields Date Math Kibana	16	7467	December 27, 2018