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	1424	July 8, 2021
Date fields comparison Kibana	3	1693	June 9, 2021
Painless Script to calculate time difference between 2 dates Elasticsearch painless	2	4491	July 15, 2022
If else Painless Script on a Painless Scripted Field Kibana painless	5	5815	July 28, 2020
Painless, if two field exists then calculate Kibana	8	43451	March 1, 2018