# Kibana data table need to have additional column to display ratio

**URL:** <https://discuss.elastic.co/t/kibana-data-table-need-to-have-additional-column-to-display-ratio/249389>\
**Category:** Kibana\
**Created:** [September 21, 2020, 3:33pm UTC](https://discuss.elastic.co/t/kibana-data-table-need-to-have-additional-column-to-display-ratio/249389 "2020-09-21T15:33:49Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![lukeelmers](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukeelmers/32/35230_2.png) [@lukeelmers](https://discuss.elastic.co/u/lukeelmers)\
**Post date:** [September 24, 2020, 5:58pm UTC](https://discuss.elastic.co/t/kibana-data-table-need-to-have-additional-column-to-display-ratio/249389/2 "2020-09-24T17:58:47Z")

</div>

Creating a new bucket based on the results of other buckets sounds like a use case for [bucket script aggregations](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-pipeline-bucket-script-aggregation.html), which unfortunately [are not yet supported everywhere in Kibana](https://github.com/elastic/kibana/issues/4707).

However, the good news is that you should be able to do something like this using TSVB, which supports bucket scripts. Here's an example of this from another thread: [Weighted Average in a DataTable of Kibana](https://discuss.elastic.co/t/weighted-average-in-a-datatable-of-kibana/185909/2)

---

_[View the full topic](https://discuss.elastic.co/t/kibana-data-table-need-to-have-additional-column-to-display-ratio/249389)._