title: Prometheus - exclude 0 values from query result
body: <p>I'm displaying Prometheus query on a Grafana table.
  That's the query (<code>Counter</code> metric):</p>
  
  <p><code>sum(increase(check_fail{app="monitor"}[20m])) by (reason)</code></p>
  
  <p>The result is a table of failure reason and its count.<br>
  The problem is that the table is also showing reasons that happened 0 times in the time frame and I don't want to display them.<br>
  AFAIK it's not possible to hide them through Grafana.</p>
  
  <p>I know prometheus has <a href="https://prometheus.io/docs/prometheus/latest/querying/operators/#comparison-binary-operators" rel="noreferrer">comparison operators</a> but I wasn't able to apply them.  </p>