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

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.