# Data table with Sum metrics and percentage column

**URL:** https://discuss.elastic.co/t/data-table-with-sum-metrics-and-percentage-column/25670
**Category:** Kibana
**Created:** [July 15, 2015, 7:18pm UTC](https://discuss.elastic.co/t/data-table-with-sum-metrics-and-percentage-column/25670 "2015-07-15T19:18:35Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![frank\_van](https://avatars.discourse-cdn.com/v4/letter/f/d26b3c/32.png) [@frank\_van](https://discuss.elastic.co/u/frank_van)
#### Post date: [July 15, 2015, 7:18pm UTC](https://discuss.elastic.co/t/data-table-with-sum-metrics-and-percentage-column/25670/1 "2015-07-15T19:18:35Z")

</div>

Hi,

I have a use case looks fairly simple but I couldn't figure out how to build a visualization for it with Kibana.

Given the following dataset:

`POST /test_index/test_type/_bulk {"index":{"_id":"1"}} {"host": "www.google.com", "hits": 100} {"index":{"_id":"2"}} {"host": "www.google.com", "hits": 20} {"index":{"_id":"3"}} {"host": "www.facebook.com", "hits": 200} {"index":{"_id":"4"}} {"host": "www.yahoo.com", "hits": 80}`

I was able to build a data table to show metrics as below:

`| Top 5 host | Sum of hits | | www.facebook.com | 200 | | www.google.com | 120 | | www.yahoo.com | 80 |`  
But I want to have an additional column to show the percentage of each unique host's count against the total count, i.e.:

`| Top 5 host | Sum of hits | % | | www.facebook.com | 200 | 50% | | www.google.com | 120 | 30% | | www.yahoo.com | 80 | 20% |`

How can I get that additional "%" column?

Thanks,  
Frank

---

<div class="post-metadata">

### Author: ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)
#### Post date: [July 16, 2015, 4:40am UTC](https://discuss.elastic.co/t/data-table-with-sum-metrics-and-percentage-column/25670/2 "2015-07-16T04:40:49Z")

</div>

This is not currently possible ☹

Could you +1 this enhancement in Github? [https://github.com/elastic/kibana/issues/2284](https://github.com/elastic/kibana/issues/2284)

The more comments - the more likely this is to bubble to the top.

---

<div class="post-metadata">

### Author: ![fares](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fares/32/45311_2.png) [@fares](https://discuss.elastic.co/u/fares)
#### Post date: [November 25, 2016, 3:02pm UTC](https://discuss.elastic.co/t/data-table-with-sum-metrics-and-percentage-column/25670/3 "2016-11-25T15:02:00Z")

</div>

Any workaround to have smthing that looks like percentage pleaaase ?  
Scripted fields may be ?

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: [July 6, 2017, 1:33pm UTC](https://discuss.elastic.co/t/data-table-with-sum-metrics-and-percentage-column/25670/4 "2017-07-06T13:33:57Z")

</div>