How to combine two columns as one in bar chart ? (not stacked)

Grafana
1

Hi there,
I’m rather new to Grafana. i’m using Grafana version 10.4.8. I’ve tried to google my problem but probably just didn’t find the right phrase to get a solution…

I have a query that returns three columns. Date, Plan Q’ty, Actual Q’ty.

image
image1386×354 38.9 KB

I want to display the results in a graph, type “bar” and the two values “Plan Q’ty” and “Actual Q’ty” are displayed above each other. Resulting in the fact, tow columns are side by side. I don’t find any so far.
This is what it looks like at the moment in Grafana:
image
image1909×266 20.6 KB

And this is what I want it to look like:
image
image968×444 19.2 KB

Any help is much appreciated!
Thx!

2

Hi,

If I understand correctly, do you want to “hide” one bar behind another? I don’t think that’s possible. What you could do (theoretically, not tested) is to calculate the difference Plan - Actual, filter only those more than 0, and stack the bars (either directly in the datasouce or in Transformations). To avoid confusion, you can also change the display.