Greetings, I am trying to create a chart that requires multiple values of data (like bar, column, area) The data I am getting from MySQL/Python looks like this:
+------------+------------------+-----+ | CDATE | component | qty | +------------+------------------+-----+ | 2013-04-02 | BPM | 4 | | 2013-04-02 | EDI | 1 | | 2013-04-02 | IT Support | 10 | | 2013-04-02 | Network Services | 1 | | 2013-04-02 | Portal | 1 | | 2013-04-02 | SAP | 9 | | 2013-04-02 | WEB | 3 | | 2013-04-03 | BPM | 1 | | 2013-04-03 | EDI | 3 | | 2013-04-03 | IT Support | 6 | | 2013-04-03 | Network Services | 1 | | 2013-04-03 | Portal | 1 | | 2013-04-03 | SAP | 5 | | 2013-04-22 | Network Services | 1 | +------------+------------------+-----+ I am using the python visualization plug in, and I'm not sure how to get the data into the format the charts need, which would be more like this: +------------+------------------+----------------+-------------------+--------+-----+----+ | CDATE | BPM | EDI | IT Support | Network Services | Portal | SAP | Web| +------------+------------------+----------------+-------------------+--------+-----+----+ | 2013-04-02 | 4 | 1 | 10 | 1 | 1 | 9 | 3 | | 2013-04-03 | 1 | 3 | 3 | 1 | 1 | 5 | 0 | | 2013-04-22 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | +------------+------------------+----------------+-------------------+--------+-----+----+ I don't think this is a simple query change because the data rows have to become column headings, and then the values need to be tallied. How are people doing this? Any help is appreciated. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
