How to sum time ranges in kibana

I have a filed in logs which shows execution time in time format like hh:mm:as

In kibana, I would like to sum all of these and show under metric.

Log value is coming in DateTime format. Please help for the solution.

In the "metrics" aggregation of your visualization, choose sum. Then pick the field that you want to sum.

But under SUM, date fields are not coming. I need to Sum Bucket and choose date field. In this case, kibana is only doing sum for hours but not for minutes and seconds.

Hi, any solution please ?

I am assuming that you are wanting to add up the time to show how long something took to execute. You will need to have a field that converts the time to an integer. That integer needs to represent something like seconds, minutes, etc. Then in kibana, you can define that field as a duration field, and define what the input and output formats will be: milliseconds, seconds, minutes, etc). I believe there are some enhancement requests in so that the output format could look like a "time" format, like HH:mm:ss.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.