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	589	April 11, 2018
Calculate the time difference between consecutive documents Elasticsearch	20	12514	May 25, 2018
Calculate differences between documents in a query Elasticsearch	5	244	March 6, 2024
Calculation time difference between two document Kibana	5	4871	April 29, 2019
Calculate a delta between two time slices Kibana	10	1194	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