PostgreSQL non-time-series graph panel visualization

Grafana
1

I’m trying to get data structured like this:

image

to look like this:

image

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

My query is:

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 < (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

Thanks!

2

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.