title: Promql percent successes by category
body: <p>I have a gauge that with label &quot;success_or_failure&quot; with values &quot;success&quot; and &quot;failure&quot;. I want to create a chart in graphana that shows the percentage of success broken down by another label &quot;category&quot;. The idea is to see the &quot;percent success&quot; for each category over time.</p>
  <p>The promql I want would be something like:</p>
  <pre><code>avg by (category) 
    (event_gauge{success_or_failure=&quot;success&quot;} / 
    ignoring(success_or_failue) group_right event_gauge)
  </code></pre>
  <p>When I do this, every charted element is equal to 1. This leads me to believe think that I'm doing it wrong. What am I doing wrong here?</p>