# How to create table with a term and percentage value from boolean property

**URL:** <https://discuss.elastic.co/t/how-to-create-table-with-a-term-and-percentage-value-from-boolean-property/262893>\
**Category:** Kibana\
**Created:** [February 1, 2021, 8:13pm UTC](https://discuss.elastic.co/t/how-to-create-table-with-a-term-and-percentage-value-from-boolean-property/262893 "2021-02-01T20:13:40Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![shellshock79](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/shellshock79/32/83240_2.png) [@shellshock79](https://discuss.elastic.co/u/shellshock79)\
**Post date:** [February 1, 2021, 8:13pm UTC](https://discuss.elastic.co/t/how-to-create-table-with-a-term-and-percentage-value-from-boolean-property/262893/1 "2021-02-01T20:13:40Z")

</div>

Hi Guys,

I have been going round and round for days with this one and seem to hit a dead end no matter what I try. I keep pushing because I have a feeling it should be fairly easy, but alas I cannot find how to do it. Please help me.

I send an object containing multiple properties. One of the properties are `$event.AssignedUser` as well as a boolean of `$event.LCSTimeSelected` indicating whether or not the user selected a suggested time when booking a fitment. This is object is created every time a user books a claim for a fitment on our system.

I would like to build a grid displaying individual users names, the count of claims they personally booked, and the percentage of times the used the suggested time vs how often the did not probably something like `$event.LCSTimeSelected:true` / sum of all claims, that the individual booked for the day

Your help is very much appreciated.

---

<div class="post-metadata">

**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\
**Post date:** [February 4, 2021, 4:34pm UTC](https://discuss.elastic.co/t/how-to-create-table-with-a-term-and-percentage-value-from-boolean-property/262893/2 "2021-02-04T16:34:39Z")

</div>

What you're really wanting to do is a bucket script, which isn't currently supported in Kibana, but has been requested for quite a long time [1]. Please add your support in the issue linked.

> <https://github.com/elastic/kibana/issues/4707>
>
> Given the rhe new Bucket Script Aggregation, we can implement formulas from aggregated metric values (e.g. metric1 / metric2 \* 100)....

Alternatively, you could use Canvas to accomplish what you want via an expression. If you'd like more information on accomplishing this, let me know and I'll be happy to help!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [March 4, 2021, 4:35pm UTC](https://discuss.elastic.co/t/how-to-create-table-with-a-term-and-percentage-value-from-boolean-property/262893/3 "2021-03-04T16:35:03Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.