Creating an x-y heatmap of counts with discrete x/y values

  • What Grafana version and what operating system are you using?

9.5 (Docker)

  • What are you trying to achieve?

I have a table of counts for combinations of two string fields with discrete values (Elasticsearch keyword fields):

I want to produce an x-y chart that shows that count in the cell, where x and y axes are the individual unique strings. Here’s an example from Kibana:

  • How are you trying to achieve it?

I don’t know how to do it. Right now I have a simple table produced by the following query:

How can I transform this to an x-y chart like the one above?