Bar chart formatting limitations?

I am using Grafana v11.3.0 (not the enterprise version)
I am trying to recreate this white chart

However, I can only get my chart to format in these three ways,.



I feel like I have tried everything, but I still can’t get it to format properly.

For reference, here is my current code:

My data source is PosgreSQL.

with only 1 transformation group by matrix, which could also be done using pivot in postgres