2D bar with data in x-axis, color, value format

Grafana Bar Chart Panel
1

I’m using this sql query:

SELECT
  g1, g2, COUNT(*)
FROM
  graph
GROUP BY
  g1, g2

With the result:

('a', 'x', 1)
('a', 'y', 2)
('b', 'x', 3)
('b', 'y', 4)

And I would like to x-axis to be a, b and colors be x,y and height the count value: like this

x: 1 3
y: 3 4
   a b
2

Transform data → Grouping to Matrix seem to work

1 Like