# Percentage only available on 1 aggregation in Data Table visualisation

**URL:** https://discuss.elastic.co/t/percentage-only-available-on-1-aggregation-in-data-table-visualisation/333984
**Category:** Kibana
**Created:** [May 22, 2023, 7:54am UTC](https://discuss.elastic.co/t/percentage-only-available-on-1-aggregation-in-data-table-visualisation/333984 "2023-05-22T07:54:47Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Wanching\_Teoh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wanching_teoh/32/121268_2.png) [@Wanching\_Teoh](https://discuss.elastic.co/u/Wanching_Teoh)
#### Post date: [May 22, 2023, 7:54am UTC](https://discuss.elastic.co/t/percentage-only-available-on-1-aggregation-in-data-table-visualisation/333984/1 "2023-05-22T07:54:47Z")

</div>

Hi,

I was trying to add percentage to two columns (4xx and 5xx) which are both an aggregation based on terms. However, from the option list, it only allow me to show percentage on one aggregation.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/7/0/707bfa46ad1f853756e731fcd9baf28767fd890b.png)

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/e/ce4ae4f418e8d62c7896d10192d3a7d10614fa49.png)

Because I am using the open-source version of Kibana which is under AWS OpenSearch which doesn't support Kibana Lens. In this case, how do I achieve percentage calculation on multiple columns (aggregations)? Is it possible that we can add percentage columns on multiple aggregations?

Thanks.

---

<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: [May 22, 2023, 7:54am UTC](https://discuss.elastic.co/t/percentage-only-available-on-1-aggregation-in-data-table-visualisation/333984/2 "2023-05-22T07:54:47Z")

</div>

OpenSearch/OpenDistro are AWS run products and differ from the original Elasticsearch and Kibana products that Elastic builds and maintains. You may need to contact them directly for further assistance.

(This is an automated response from your friendly Elastic bot. Please report this post if you have any suggestions or concerns :elasticheart: )

---

<div class="post-metadata">

### Author: ![henry22](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/henry22/32/113545_2.png) [@henry22](https://discuss.elastic.co/u/henry22)
#### Post date: [May 22, 2023, 8:29am UTC](https://discuss.elastic.co/t/percentage-only-available-on-1-aggregation-in-data-table-visualisation/333984/3 "2023-05-22T08:29:20Z")

</div>

Maybe you can run two separate aggregations through kibana?  
Otherwise, you might have to run two aggregations through the console.

---

<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: [June 19, 2023, 8:30am UTC](https://discuss.elastic.co/t/percentage-only-available-on-1-aggregation-in-data-table-visualisation/333984/4 "2023-06-19T08:30:15Z")

</div>

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