Today, there is no utility in the visualization library to do it. I hope to add it some time, but I don't know what it will happen yet.Where do you get the data from? Note that if you take it from Google Spreadsheet, then you may use the query language tin the request to pivot the data.
Otherwise, for now, you have to do it yourself in javascript, and to create another data table. Regards, VizGuy On Wed, Apr 22, 2009 at 11:49 PM, rhoneil <[email protected]> wrote: > > is there any way I can take data like this: > > function drawTable() { > var data = new google.visualization.DataTable(); > data.addColumn('string', 'Name'); > data.addColumn('number', 'Salary'); > data.addColumn('boolean', 'Full Time Employee'); > data.addRows(4); > data.setCell(0, 0, 'Mike'); > data.setCell(0, 1, 10000, '$10,000'); > data.setCell(0, 2, true); > data.setCell(1, 0, 'Jim'); > data.setCell(1, 1, 8000, '$8,000'); > data.setCell(1, 2, false); > data.setCell(2, 0, 'Alice'); > data.setCell(2, 1, 12500, '$12,500'); > data.setCell(2, 2, true); > data.setCell(3, 0, 'Bob'); > data.setCell(3, 1, 7000, '$7,000'); > data.setCell(3, 2, true); > > and do a pivot on it before using a table visualization? > > (this data may be a bad example but i think you get the picture) > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en -~----------~----~----~----~------~----~------~--~---
