How to query a sum and it's percentage in the same query?

[Tortoise]

Hello @khat33b

Please check below post regarding your question to show % , if it is helpful :

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

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", "…

Thanks!!