Awesome thanks. On a related note, its a shame that GAE doesn't allow server side chart creation. I worked out that its *way* more bandwidth sending a large table via JSON to a client for them to render then simply sending a png of a rendered chart. I realize that its hard for GAE to support graphics libs as they depend on native code, but still...doesn't using the visualization API cause for undue amounts of net traffic in the case of large datasets?
Rob On Dec 6, 3:17 pm, VizGuy <[email protected]> wrote: > This is a bug in DataView sort, and we are fixing it. > Will be loaded in the next release. > > Thanks for reporting, > VizGuy > > > > On Sun, Dec 6, 2009 at 3:39 AM, RobT <[email protected]> wrote: > > Took me a while to track this down but I'm pretty sure that the Table > > visualization dies in the case of a calculated column (or perhaps just > > the calculated column i'm using to remove nulls. Anyway here's an > > example. The ImageChart works well with the same visualization. > > Here's an example you can post in the Code Playground. > > > <!-- > > copyright (c) 2009 Google inc. > > > You are free to copy and use this sample. > > License can be found here: > >http://code.google.com/apis/ajaxsearch/faq/#license > > --> > > > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http:// > >www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> > > <html xmlns="http://www.w3.org/1999/xhtml";> > > <head> > > <meta http-equiv="content-type" content="text/html; charset=utf-8"/ > > > <title> > > Google Visualization API Sample > > </title> > > <script type="text/javascript" src="http://www.google.com/jsapi";></ > > script> > > <script type="text/javascript"> > > google.load('visualization', '1', {packages: ['imagelinechart', > > 'table']}); > > </script> > > <script type="text/javascript"> > > function drawVisualization() { > > // Create and populate the data table. > > var data = new google.visualization.DataTable(); > > data.addColumn('string', 'Name'); > > data.addColumn('number', 'Height'); > > data.addColumn('number', 'age'); > > data.addRows(5); > > data.setCell(0, 0, 'Tong Ning mu'); > > data.setCell(1, 0, 'Huang Ang fa'); > > data.setCell(2, 0, 'Teng nu'); > > data.setCell(3, 0, 'Teng nu'); > > data.setCell(4, 0, 'Teng nu'); > > data.setCell(0, 1, 174); > > data.setCell(1, 1, 523); > > //data.setCell(2, 1, 86); > > data.setCell(3, 1, 234); > > data.setCell(4, 1, 23); > > data.setCell(1,2,23); > > data.setCell(1,2,2); > > data.setCell(2,2,3); > > //data.setCell(3,2,2); > > data.setCell(4,2,32); > > > function myFunc(dv, rn) { > > var val = dv.getValue(rn, 1); > > if(val == null) { > > return 0; > > } else { > > return val; > > } > > } > > > var vis = new google.visualization.DataView(data); > > vis.setColumns([0,{calc:myFunc, type:'number'}]); > > > // Create and draw the visualization. > > new google.visualization.ImageLineChart(document.getElementById > > ('visualization')). > > draw(vis, null); > > new google.visualization.Table(document.getElementById > > ('table')). > > draw(vis, null); > > } > > > google.setOnLoadCallback(drawVisualization); > > </script> > > </head> > > <body style="font-family: Arial;border: 0 none;"> > > <div id="visualization" style="width: 300px; height: 300px;"></ > > div> > > <div id='table'></div> > > </body> > > </html> > > > -- > > > 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]<google-visualization- > > api%[email protected]> > > . > > For more options, visit this group at > >http://groups.google.com/group/google-visualization-api?hl=en. -- 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.
