Creating a Kinana table using a multi-field with es|ql

Elastic Stack Kibana
1

v 8.17.4
I am trying to create a visualisation table in Kibana using an es|ql query.
The main field in question is a Keyword multi-field call ItemsFound.
I want the first column to be a list of unique items found.
Column two is a count of the ItemsFound
Column three will be a percentage of ItemsFound
I can get the first two columns working just using Kibana but I can't get the percentage, even with a formula.

ItemsFound [ "Item B", "Item W", "Item H" ]
ItemsFound [ "Item B", "Item R", "Item H" ]
ItemsFound [ "Item H", "Item C", "Item F" ]

Items Items count Items %
Item B 60 60%
Item H 30 30%
Item C 15 15%
Item W 5 50
2

Hi @Robin_Gorry

that is currently not possible with ES|QL yet.

3

Hello @Robin_Gorry

I have a Work Around if it works for you, while using the ES|QL instead of bar select Pie & it automatically converts it into percentage :

image
image1888×577 64.8 KB

This you can use it on a Dashboard , where in table it will show the data & it will also show the Pie diagram separately not within the table .

Thanks!!