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

[sanjaysubramanian]

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

[mikecote (Mike)]

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.