PostgreSQL non-time-series graph panel visualization

I’m trying to get data structured like this:


to look like this:


I am using the Graph Visualization with X-Axis mode set to Series.

My query is:

select as Value,
	round(sum(i.points)/12, 1) as Metric
	event e,
	issue i,
	team t
	i.key = e.issue
	and = i.assignee
	and e.type = 'Closed'
	and t.role = 'DEVELOPER'
	and < (now() - interval '1 year')
group by Value
order by Metric

I’ve been reading Community topics and modifying my query for days. I would really appreciate some help.

Grafana Version: v6.4.0 (c3b3ad4)
PostgreSQL Version: 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


I also posted this on StackOverflow and it was answered there first. The short answer is that Grafana is still oriented exclusively to time-series data and you have to fake it out to get it to work for non-time-series data. Link to the full answer here.