Stacked Bar chart with MySQL

1

How can you create stacked bar charts with multiple mysql informations?
This is my SQL syntax:

SELECT
  now() as time,
  profiles.name as name,
  SUM(IF(bugs.bug_status = "NEW", 1, 0)) AS new,
  SUM(IF(bugs.bug_status = "UNCONFIRMED", 1, 0)) AS unconfirmed,
  SUM(IF(bugs.bug_status = "CONFIRMED", 1, 0)) AS confirmed,
  SUM(IF(bugs.bug_status = "ASSIGNED", 1, 0)) AS assigned,
  SUM(IF(bugs.bug_status = "REOPENED", 1, 0)) AS reopened,
  SUM(IF(bugs.bug_status = "RESOLVED", 1, 0)) AS resolved,
  SUM(IF(bugs.bug_status = "READY FOR TESTING", 1, 0)) AS rft
FROM bugs
LEFT JOIN profiles ON bugs.assigned_to = profiles.userid
WHERE profiles.is_enabled = 1
GROUP BY name

But it looks like this:

25
251649×305 25.2 KB

I have enabled Stack. I have tried to set the Stacked value to cumulative and individual but doesn’t works.

I would like that new, unconfirmed, assigned, reopened, resolved, and rft get stacked in to one bar

Thanks.