Feature Request: Option to hide zero values in legend and tooltip

[jmcle]

The new options to hide null values in the legend and 'all series' tooltip are excellent but I run into a problem when using them with stacked bar graphs.

With stacked graphs we need to set 'null as zero' in order to get the stacking to work properly but this negatively impacts the ability to hide null values in the legend and tooltip as null values will show up as zero instead of null.

I'm not sure if there's a better way to address this but one option would be to add an option to 'hide zero values' in addition to the existing 'hide null values'. Another option would be to make the 'hide value' option a parameter which you could set to any numeric value. This would be similar to what the 'removeBelowValue' function does but in this case it would affect the display of legends and tooltips.

[fzaire]

I have the same issue and I end up with 80% of the metrics in my legend with 0 value that i need to hide.
If more people are facing the same issue, we could try to commit this feature.

[torkelo]

cant you filter out the zero metrics/series in your query?

[linar-jether]

+1 for this issue, as we can't filter out zeroes without breaking stacks, i.e

[agourlay]

+1 for this issue.

[apakulov]

+1

[utkarshcmu]

+1

[digrich]

+1

[george-vieira]

I have the same issue, my metrics shows traffic by IP and they spike in and out so at any point in time there could be values or 0. The tooltip shows 100 IPs which is overall but I only care of the point in time I'm hovering over.

[utkarshcmu]

The above PR only hides the zero values if all datapoints are 0. Even if a single datapoint is non-zero on the graph for a given time range, it will not hide the metric.

[Pryz]

+1

It could be nice to specify a pattern. Like "hide if < 0" or "hide if = 0" etc

[utkarshcmu]

As an example, Opentsdb cannot remove zeros in query itself, so it would be great if Grafana can eliminate them from Legend and Tooltip. And looks like a lot of people wants this feature to be there in Grafana.

@torkelo Are these +1s enough for #3336 to get merged? Please let me know if any refinement is needed in the PR #3336.

[dacr]

+1

with a pattern such as "hide when no value" (in current time range)

[torkelo]