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

[hodung]

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.

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:

And this is what I want it to look like:

Any help is much appreciated!
Thx!

[dawiddebowski]

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.

[robbertvld]

In the newer version of Grafana you have the option to use Trend visualizations. This makes this possible.
Use the graph style ‘bars‘ and you get: