Scripted field to display custom metrics in a table visualization

Elastic Stack Kibana
1

Hi, I'm new to scripted fields in Kibana.
I have created a really simple table visualization which has an Average as metric and other Terms as Buckets. Therefore the output is like this:

Items    Average
---------------------
Item1    x
Item2    y
Item3    z
...
ItemN    t

What I would like to achieve is getting another column which is based on a formula:

NewColumn = Number of ItemX items which have Average greater than x% / Total number of ItemX

It would be very beneficial to me to get an example :slight_smile:

2

Hi espogian, I don't think it's possible within our table visualizations. You may be able to do something similar using a filter ratio. See this thread for an example of that:

Best of luck!