Hi I have some documents with a field called "duration", in the format HH:MM:SS. I would like to calculate the sum of the duration of the documents i have filtered by a date. However, when trying to sum the data, since it is not a numeric field it is not displayed in the field list What can i do t…

Calculate total time of a list of documents

javidr (javi) January 3, 2022, 6:41pm 3

yeah but it will not be displayed as a HH:MM:SS field. It is, if i have two documents, with 3600 and 3601 seconds, i want to display 02:00:01

Thanks

Topic		Replies	Views
How to sum the duration dates given in HH:mm:ss? Kibana	2	1014	July 6, 2017
How to do time math in script field Kibana	3	388	May 5, 2020
How to sum date values in kibana Kibana	5	1108	January 19, 2019
Operation on "total" value of Data Table Kibana	2	600	October 23, 2017
Scripted field to calculate duration Kibana	9	3717	September 15, 2020

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 total time of a list of documents

Related topics