Grafana multi series graph

Grafana MySQL
,
1

I want to create a multi series graph , but the metric name is keep on repeating for each graph.
I had two mysql queries and each queries appearing one by one and not overlapping. Below I pasted the graph and two queries. Kindly suggest.

grafana
grafana1558×344 6.02 KB

Mysql queries are:
A:
SELECT
UNIX_TIMESTAMP(creation_Date) as time_sec,
count(status) as value,
month as metric
FROM 'january'
where Source=‘RTC’
group by status;
B:
SELECT
UNIX_TIMESTAMP(creation_Date) as time_sec,
count(status) as value,
month as metric
FROM 'january'
where Source=‘Doors’
group by status;

2

Think you need to group by time_sec and month. But I’m a bit unsure if you want to have the count per month or what?

Marcus

3

Thanks for you response. Yes i need count per month as a stacked graph. If possible kindly write mysql query for us.

Below is the example image for my expectation.
image_stacked_bar_chart_resized

4

Stacked mode is not supported in series mode, only in time series mode. There’s an open feature request issue for that.