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
exportDate|grouping|total
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.
mike
