Unable to create stacking Bar chart with 2 different time series data

Hi Team,

I’m using grafana 8.3 with zabbix plugin. I get a time series data from zabbix and have to plot bar chart for vCPU allocation vs utilization. something like as below -

I have configured 2 different metrics - one to get vCPUs allocated data and the other to get vCPUs utlized data. I have some challenges in clubbing both the data and display a graph as above. Did anyone tried this scenario before ?

Looking for a support.
Thanks,
Sudharsan

welcome to the :grafana: forum, @sudharsanraghavan

it looks like you might want to use the Bar Chart, which uses arbitrary strings on the x axis:

https://play.grafana.org/d/ktMs4D6Mk/5-bar-charts-and-pie-charts?orgId=1

See the docs for the data model that you will need to fit:

In my case, we are using zabbix plugin and using 2 different queries to fetch the online data. the query outputs 2 different tables and after merging we are not getting the table structure as defined in above example. we applied in built functions but still no luck. any other sample graphs you have with zabbix plugin ?