I have a set of records which include
- times - how much times the event has been executed
- time_sum - sum of events execution time.
Such events are published with interval of 5 seconds. I would like to visualize an average of execution time for every 5 minutes. What I should do is sum(times) for 5 minutes / sum(time_sum) for 5 minutes for each 5 minutes. Does Kibana allow to do It using regular Kibana visualizations?
PS. I use Micrometer library for publishing metrics to Elasticsearch. And I asked the Micrometer's developers to give an ability to set different reporting step for metrics to avoid such aggregations on Kibana side. Here is the link.