# How to suppress Metric Sum(Counts) == 0 in Kibana PIECHART

**URL:** <https://discuss.elastic.co/t/how-to-suppress-metric-sum-counts-0-in-kibana-piechart/236781>\
**Category:** Kibana\
**Created:** [June 11, 2020, 8:40pm UTC](https://discuss.elastic.co/t/how-to-suppress-metric-sum-counts-0-in-kibana-piechart/236781 "2020-06-11T20:40:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sanjaysubramanian](https://avatars.discourse-cdn.com/v4/letter/s/bcef8e/32.png) [@sanjaysubramanian](https://discuss.elastic.co/u/sanjaysubramanian)\
**Post date:** [June 11, 2020, 8:40pm UTC](https://discuss.elastic.co/t/how-to-suppress-metric-sum-counts-0-in-kibana-piechart/236781/1 "2020-06-11T20:40:27Z")

</div>

Hi all

My Kibana version is 7.7.0

I am drawing a PIE CHART visualization of the histogram of Devices that users have used to access the website.

In this case the values are  
Other Other = 1318  
Chrome Windows = 5  
Chrome Mac OS X = 0

I want to suppress "Chrome Mac OS X" in the Legend if the SUM(COUNTS) == 0

 ![1visual](https://us1.discourse-cdn.com/elastic/original/3X/6/8/689b80992f1da6dc8aa81a24fc8c3fe2b179567e.png) ![2table](https://us1.discourse-cdn.com/elastic/original/3X/5/9/5926f8808d20f56412fbf59e371cb3cf325cde97.png)

---

<div class="post-metadata">

**Author:** ![mikecote](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mikecote/32/58549_2.png) [@mikecote](https://discuss.elastic.co/u/mikecote)\
**Post date:** [June 18, 2020, 5:12pm UTC](https://discuss.elastic.co/t/how-to-suppress-metric-sum-counts-0-in-kibana-piechart/236781/2 "2020-06-18T17:12:07Z")

</div>

Hi @sanjaysubramanian,

You should be able to use the filters on the top left to exclude data points that cause a sum of `0`. Probably by using the "is not" operator with a value of `0` on the field you're doing a count on.

---

<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 16, 2020, 5:23pm UTC](https://discuss.elastic.co/t/how-to-suppress-metric-sum-counts-0-in-kibana-piechart/236781/3 "2020-07-16T17:23:22Z")

</div>

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