Kibana data table need to have additional column to display ratio

Elastic Stack Kibana
1

In Kibana data table, i have two columns which is an aggregation of two fields. Say sum of task-started and sum of task-completed. I need to have a third column which is a ratio of two aggregated columns. How to achieve this?

I am using Elastic Cloud v 7.5.

2

Creating a new bucket based on the results of other buckets sounds like a use case for bucket script aggregations, which unfortunately are not yet supported everywhere in Kibana.

However, the good news is that you should be able to do something like this using TSVB, which supports bucket scripts. Here's an example of this from another thread: Weighted Average in a DataTable of Kibana

3

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