Group by and Sum

[nickpeihl]

I think you should be able to do this with either Visual Builder or Timelion.

Here's an answer to a similar question.

Calculate average in Kibana visualizations

Hi, what you are looking for is the bucket script aggregation, which allows you to calculate the outcome of several metric aggregations. This is not yet completely implemented in Kibana, see also https://github.com/elastic/kibana/issues/4707 Nevertheless you could actually achieve that (using Bucket Script aka Calculation) in Visual Builder, where you would just create two sum aggregations (for times and time_sum) and then create a script, that will divide those two and draw this one. The sam…