Stacked Bar charts using Mysql Data Source

I am using mysql data source and trying to create a stacked bar chart with mysql query. But when i enabled stack option it’s not working. So Can someone help me in mysql query for a stacked bar chart. And further any modifications i need to do in display,Axes options.

Any insight into this one yet?

Did you ever resolve this?