Stacked Bar charts in centos for mysql data source

Grafana Time Series Panel
1

Hi, I am using mysql data source in centos and I am trying to generate a stacked bar chart in which i need to stack based on status of bug like (opened,closed,resolved). i need to modify this below sql query. can someone help me in this query? Thanks in advance

SELECT
UNIX_TIMESTAMP(Created_On) as time_sec,
COUNT(Bug) as value,
WEEK(Created_On,1) as metric
FROM bug_status
WHERE $__timeFilter(Created_On)
GROUP BY Created_On
ORDER BY time_sec ASC

2

Sorry, you will likely not find someone who is willing to write SQL for you here. But a tip would be to use bug_status as the metric name, not the created_On column.

1 Like
3

Thanks for the reply