Sign in to follow this  

StCol2DLineDY population from mySql

Recommended Posts

i'm trying to populate the dataset hopefully via the addDatasetsFromDatabase function




mysql query:




select distinct(concat(monthname(exportDate),' ',year(exportDate))) as exportDate, grouping, total from summary group by year(exportDate), month(exportDate), grouping






March 2010|g1|10


March 2010|g2|8


March 2010|g3|21


March 2010|g4|2








i'm adding March 2010 and other months via distinct(...) from another query, and i need to group g1 & g2 to the left stack, and g3 & g4 on the right stack




tnx in advance.





Share this post

Link to post
Share on other sites



This Dual Y chart does not have a right stack. The stacked chart is at the left as primary and lines can be created on the secondary or left axis. You can add an array of dataset settings where for the last two datasets you need to set parentYAxis=s

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this