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

**URL:** <https://discuss.elastic.co/t/creating-a-kinana-table-using-a-multi-field-with-es-ql/377972>\
**Category:** Kibana\
**Created:** [May 9, 2025, 3:46am UTC](https://discuss.elastic.co/t/creating-a-kinana-table-using-a-multi-field-with-es-ql/377972 "2025-05-09T03:46:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robin\_Gorry](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/robin_gorry/32/142231_2.png) [@Robin\_Gorry](https://discuss.elastic.co/u/Robin_Gorry)\
**Post date:** [May 9, 2025, 3:46am UTC](https://discuss.elastic.co/t/creating-a-kinana-table-using-a-multi-field-with-es-ql/377972/1 "2025-05-09T03:46:41Z")

</div>

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 |

---

<div class="post-metadata">

**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\
**Post date:** [May 19, 2025, 10:16am UTC](https://discuss.elastic.co/t/creating-a-kinana-table-using-a-multi-field-with-es-ql/377972/2 "2025-05-19T10:16:30Z")

</div>

Hi @Robin_Gorry

that is currently not possible with ES|QL yet.

---

<div class="post-metadata">

**Author:** ![Tortoise](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tortoise/32/147587_2.png) [@Tortoise](https://discuss.elastic.co/u/Tortoise)\
**Post date:** [May 19, 2025, 11:24am UTC](https://discuss.elastic.co/t/creating-a-kinana-table-using-a-multi-field-with-es-ql/377972/3 "2025-05-19T11:24:29Z")

</div>

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](https://us1.discourse-cdn.com/elastic/original/3X/6/7/6703095447f4d95762ecf2cfeacec41c8247a877.png)

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!!