# How can I display count instead of percentage in pie

**URL:** https://discuss.elastic.co/t/how-can-i-display-count-instead-of-percentage-in-pie/150992
**Category:** Kibana
**Created:** [October 4, 2018, 8:10am UTC](https://discuss.elastic.co/t/how-can-i-display-count-instead-of-percentage-in-pie/150992 "2018-10-04T08:10:09Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![Denis\_Tatarenko](https://avatars.discourse-cdn.com/v4/letter/d/a698b9/32.png) [@Denis\_Tatarenko](https://discuss.elastic.co/u/Denis_Tatarenko)
#### Post date: [October 4, 2018, 8:10am UTC](https://discuss.elastic.co/t/how-can-i-display-count-instead-of-percentage-in-pie/150992/1 "2018-10-04T08:10:09Z")

</div>

I have simple pie-chart visualization.  
I want to display labels on the chart with values,  
however when go to "Labels Settings" and enable "Show Values", it shows only percentage,  
How can I display count instead?

---

<div class="post-metadata">

### Author: ![popa](https://avatars.discourse-cdn.com/v4/letter/p/dec6dc/32.png) [@popa](https://discuss.elastic.co/u/popa)
#### Post date: [October 4, 2018, 8:17am UTC](https://discuss.elastic.co/t/how-can-i-display-count-instead-of-percentage-in-pie/150992/2 "2018-10-04T08:17:57Z")

</div>

Doesn't look like it's currently possible to show the count with the label:

> [@How do I display count in kibana 6 pie legend?](https://discuss.elastic.co/t/how-do-i-display-count-in-kibana-6-pie-legend/121283):
>
> I'm creating visualization (pie chart) for response codes from apache\_error and apache\_access logs. This works great but how can I add count next to 'codes' in the legend. Please see attached picture. Any advice appreciated, Thank you

However, if you hover over each slice of the pie, you should see the percentage plus the count.

---

<div class="post-metadata">

### Author: ![Denis\_Tatarenko](https://avatars.discourse-cdn.com/v4/letter/d/a698b9/32.png) [@Denis\_Tatarenko](https://discuss.elastic.co/u/Denis_Tatarenko)
#### Post date: [October 4, 2018, 8:34am UTC](https://discuss.elastic.co/t/how-can-i-display-count-instead-of-percentage-in-pie/150992/3 "2018-10-04T08:34:12Z")

</div>

The answer in this post has some "You can enable it" and that's actually what I've done.

> 

Kibana 6.1 add pie labels that show the metric value. You can enable them under options -\> Labels Settings -\> Show Labels

> 

And I'm ok with displaying count+percentage, but I have no "hover" options, since metric planned to be displayed statically, without user interactions.

It's strange if it's not possible, because previously the was an inverted issue (cant display percentage)

---

<div class="post-metadata">

### Author: ![popa](https://avatars.discourse-cdn.com/v4/letter/p/dec6dc/32.png) [@popa](https://discuss.elastic.co/u/popa)
#### Post date: [October 5, 2018, 12:51am UTC](https://discuss.elastic.co/t/how-can-i-display-count-instead-of-percentage-in-pie/150992/4 "2018-10-05T00:51:39Z")

</div>

I've just created a pie chart in Kibana 6.4.0. In the "Options" menu you need to select "Show Tooltip" to see the percentages and count.

For my example, I'm doing a term count for port names (http, https, telnet, etc). The legend only shows the port name, however, when I hover over each slice of the chart it shows the value, count, and percentage:

| field | value | count |
| --- | --- | --- |
| event\_data.DestinationPortName:Descending | http | 13 (13.83%) |

---

<div class="post-metadata">

### Author: ![Denis\_Tatarenko](https://avatars.discourse-cdn.com/v4/letter/d/a698b9/32.png) [@Denis\_Tatarenko](https://discuss.elastic.co/u/Denis_Tatarenko)
#### Post date: [October 5, 2018, 4:50am UTC](https://discuss.elastic.co/t/how-can-i-display-count-instead-of-percentage-in-pie/150992/5 "2018-10-05T04:50:58Z")

</div>

Popa, once again, I don't need it in tooltip. I need it in the label, that's desired to be shown on the display without any mouse or keyboard, for monitoring errors amount, so it should not require any user actions to show count.

---

<div class="post-metadata">

### Author: ![popa](https://avatars.discourse-cdn.com/v4/letter/p/dec6dc/32.png) [@popa](https://discuss.elastic.co/u/popa)
#### Post date: [October 5, 2018, 5:21am UTC](https://discuss.elastic.co/t/how-can-i-display-count-instead-of-percentage-in-pie/150992/6 "2018-10-05T05:21:07Z")

</div>

Got ya. I understand.

I'm also encountering this same issue when visualizing certain event types. For example, if I visualize a field that has a numerical value (event\_id: 1), and do a count, it shows both the value and the percentage.

However, when I do the same for something like (hostname: COMPUTER001), it will only show the percentage value when show values and show labels is enabled.

---

<div class="post-metadata">

### Author: ![Denis\_Tatarenko](https://avatars.discourse-cdn.com/v4/letter/d/a698b9/32.png) [@Denis\_Tatarenko](https://discuss.elastic.co/u/Denis_Tatarenko)
#### Post date: [October 5, 2018, 7:18am UTC](https://discuss.elastic.co/t/how-can-i-display-count-instead-of-percentage-in-pie/150992/7 "2018-10-05T07:18:38Z")

</div>

Hmm, that's interesting. Indeed I have aggregation by Terms.  
Maybe there is a way to transform terms into some numeric values ?  
"COMPUTER001" : 1,  
"COMPUTER002" : 1,  
"COMPUTER003" : 1,  
....  
"COMPUTER0011" : 1,

---

<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: [November 2, 2018, 7:18am UTC](https://discuss.elastic.co/t/how-can-i-display-count-instead-of-percentage-in-pie/150992/8 "2018-11-02T07:18:40Z")

</div>

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