Problem creating stacked Bar Charts on Grafana using data from mysql

Grafana
1

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:

stacked_graph
stacked_graph862×447 13.4 KB

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!

query
query771×243 21.6 KB

Your help will be massively appreciated! thank you

2

Hi,

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: https://github.com/grafana/grafana/issues/7949 (you can add your thumbs up to push this feature)