Problem creating stacked Bar Charts on Grafana using data from mysql

I have monthly total active users from 3 different locations. the database doesn’t have timestamp and the way I query the data is based on the user startDate and endDate employment contract.

the total users from 3 different locations should be stacked in one bar, but mine is side by side as bellow:

here’s the snapshot of my queries, not sure this is the most efficient way for getting total active user for rolling 12 months. I am totally Newbie!

Your help will be massively appreciated! thank you


It’s not possible to do this right now for non time-series data as the “Series” Mode for the X-Axis and the “Stack” options are not compatible. There is an issue open about this here: (you can add your thumbs up to push this feature)