If your database supports pivot queries, then you can pivot your data at the query level to get it into the correct structure. If it doesn't support pivot queries, then you will have to manually pivot the data in javascript. I have a demo of how to manually pivot a DataTable here: http://jsfiddle.net/asgallant/HkjDe/
On Wednesday, July 31, 2013 9:30:04 AM UTC-4, armon d wrote: > > but i can't change my data base, i want to know that, with out changing my > data base i can do it ????? > On Tuesday, July 30, 2013 2:24:05 PM UTC+2, armon d wrote: >> >> hello >> >> I want to use "PieChart", "ComboChart" and "Control" in a such way that >> "Control" would be able to adjust "Pie" and "Combo". The problem starts >> when my Database in like this: >> ['Name', 'Age', 'date', 'ville'], >> ['Michael' , 12, 2012, 'A'], >> ['Elisa', 20, 2012, 'B'], >> ['Robert', 7, 2012, 'A'], >> ['Michael', 54, 2013, 'A'], >> ['Elisa', 22, 2013, 'E'], >> ['Robert', 3, 2013, 'F'], >> ['Michael', 42, 2014, 'G'], >> ['Elisa', 33, 2014, 'H'], >> ['Robert', 42, 2014, 'G'] >> >> I wish "ComboCahrt" to perform like what this link illustrates: >> >> https://google-developers.appspot.com/chart/interactive/docs/gallery/combochart >> >> Having such the output, we need to retrieve a query for the >> "ComboChart". My script is found in this link >> http://jsfiddle.net/alirezamoussaei/SNRRr/1/ >> >> I will be appreciated it if you could make changes to correct the code: >> ... >> P.S: I employed "BarChart" in my code. Please let me know how to change >> it to "ComboChart". >> > -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/groups/opt_out.
