# Calculate ratio beetwin count and unique count

**URL:** <https://discuss.elastic.co/t/calculate-ratio-beetwin-count-and-unique-count/294588>\
**Category:** Kibana\
**Created:** [January 17, 2022, 1:09pm UTC](https://discuss.elastic.co/t/calculate-ratio-beetwin-count-and-unique-count/294588 "2022-01-17T13:09:33Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Tomo\_M](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@Tomo\_M](https://discuss.elastic.co/u/Tomo_M)\
**Post date:** [January 17, 2022, 1:29pm UTC](https://discuss.elastic.co/t/calculate-ratio-beetwin-count-and-unique-count/294588/2 "2022-01-17T13:29:07Z")

</div>

Hello,

I suppose this topic is related to you. Only with kibana seems impossible unfortunately, but transform may be a possible solution.

> [@Add a column based on a Bucket Script Aggregation or other columns into a Data Table visualization](https://discuss.elastic.co/t/add-a-column-based-on-a-bucket-script-aggregation-or-other-columns-into-a-data-table-visualization/229250):
>
> I am building a Data Table in which I could get two required columns but I need to add one additional column which is the difference between these two. Is that somehow possible? I could get the desired results using a Bucket Script Aggregation, but how can I use this in the Data Table? Please consider the following mock-up case for a better explanation. The case is for performance metrics recorded for different machine learning models per customer. We need to show a summary table of the averag…

---

_[View the full topic](https://discuss.elastic.co/t/calculate-ratio-beetwin-count-and-unique-count/294588)._
