I am trying to determine the meantime between records, per month, for a set of documents. All documents have a timestamp, and I want to capture the average time between the timestamps on a monthly basis. Have tried several trial and error approaches, but nothing is giving me exactly what I want. D…

Mean Time Between Documents

jduquette (John Duquette) June 19, 2018, 10:53pm 3

That is exactly right. Sum of all deltas over total document count: Σ[(t[N] - t[N-1])]/N

Topic		Replies	Views
Serial difference of timestamps between documents Elasticsearch	1	683	April 18, 2019
Time Difference between Documents Elasticsearch	2	2300	July 5, 2017
Calculate the time difference between consecutive documents Elasticsearch	20	12730	May 25, 2018
Calculating the avg time between two time stamps Elasticsearch	3	2260	July 6, 2017
Calculate time using timestamp! Elasticsearch	6	4972	July 6, 2017

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.

Mean Time Between Documents

Related topics