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
Calculate the time difference between consecutive documents Elasticsearch	20	12501	May 25, 2018
Calculate differences between documents in a query Elasticsearch	5	239	March 6, 2024
Calculation time difference between two document Kibana	5	4861	April 29, 2019
Calculate a delta between two time slices Kibana	10	1175	July 22, 2022
Identify the difference in data for two successive days Elasticsearch	2	11	July 15, 2024

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