title: Grafana PostgreSQL non-time-series graph panel visualization
body: <p>I’m trying to get data structured like this:</p>
  
  <hr>
  
  <p><a href="https://i.stack.imgur.com/N78Su.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/N78Su.png" alt="Query Results"></a></p>
  
  <hr>
  
  <p>to look like this:</p>
  
  <hr>
  
  <p><a href="https://i.stack.imgur.com/2xa68.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2xa68.png" alt="Basic Bar Chart"></a></p>
  
  <hr>
  
  <p>I am using the Graph Visualization with X-Axis mode set to Series.</p>
  
  <p>My query is:</p>
  
  <pre><code>select
      t.name as Value,
      round(sum(i.points)/12, 1) as Metric
  from
      event e,
      issue i,
      team t
  where
      i.key = e.issue
      and t.id = i.assignee
      and e.type = 'Closed'
      and t.role = 'DEVELOPER'
      and e.date &lt; (now() - interval '1 year')
  group by Value
  order by Metric
  ;
  </code></pre>
  
  <p>I’ve been reading Grafana Community topics and modifying my query for days. I can change the query/data structure to make this work. I would really appreciate some help.</p>
  
  <ul>
  <li><strong>Grafana Version</strong>: v6.4.0 (c3b3ad4)</li>
  <li><strong>PostgreSQL Version</strong>: PostgreSQL 10.9 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-11), 64-bit</li>
  </ul>
  
  <p>Thanks!</p>