Hi, I have two terms in a log that we will call X and Y from date format. I want to send a query that will show me all logs that the value of (X-Y) is greater than 3 (seconds). How can I do this?

If your 2 related dates (start, end) are held on the same JSON document then your problem is simpler. Either use a script at query time to subtract (slower, harder for Kibana end users) or Reindex your content performing the subtraction at insert time (using custom app logic or ingest pipeline) M…

Discuss the Elastic Stack

Query checking difference of two terms in a log

Elastic Stack Elasticsearch

Mark_Harwood (Mark Harwood) September 5, 2017, 7:39am 2

See How to calculate duration in aggregation?

1 Like

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.