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.
