We need to calculate diff between two readings in two consecutive records. Rec 1 = time1, meter reading 1 Rec 2 = time 2, meter reading 2 Consumption between time 2 – time 1 = meter reading 2 – meter reading 1

Calculate difference between two consecutive rows

Mark_Harwood (Mark Harwood) May 15, 2018, 7:29am 2

Topic		Replies	Views
Difference between consecutive records using derivative aggregation Elasticsearch	1	593	April 11, 2018
Calculate the time difference between consecutive documents Elasticsearch	20	12530	May 25, 2018
Calculate differences between documents in a query Elasticsearch	5	247	March 6, 2024
Calculation time difference between two document Kibana	5	4883	April 29, 2019
Calculate a delta between two time slices Kibana	10	1212	July 22, 2022

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.

Calculate difference between two consecutive rows

Related topics