Divide 2 metrics in kibana

Hi. I have 2 metrics that shows unique count of users and total streamed time.
I wanna have avg streamed time per client.


How can I divide these 2 metrics ? some pipeline aggregation or script ? Thanx a lot

Hi if your index has a time field, then you can use TSVB and apply a bucket script between the two aggregations like in this example:

Keep in mind that TSVB displays the last available bucket, so if you have to cover fully your time range you should change the interval in the Panel Options to something larger than the time range you wanna use on your dashboard.
Starting from version 7.4 it's a bit more easy to configure TSVB to display the value time range.

1 Like

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