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