Thank you so much. I am going to try it! I got distracted by another problem.
On Monday, May 28, 2012 10:23:44 AM UTC-7, far m wrote: > > So, I can do a query and get the right columns out of a file and create a > data = response.getDataTable() > But I want to extract the last value of each column and display each on a > separate gauge. Here is the basic idea: > http://jsfiddle.net/essonoma/tQry2/#base > > google.load('visualization', '1', {packages: ['gauge']}); > google.setOnLoadCallback(drawVisualization); > > > function drawVisualization() { > > var query = new google.visualization.Query(' > https://docs.google.com/spreadsheet/ccc?key=0AqzQGhNv6cV-dDBzZmZ2NzVGSkVVTUEwMEZPOG5YTHc#gid=0 > '); > > // Apply query language. > query.setQuery('SELECT A,B,C'); //<<< -- Should I use??? LAST()? > > // Send the query with a callback function. > query.send(handleQueryResponse); > } end of th efunction > > function handleQueryResponse(response) { > if (response.isError()) { > alert('Error in query: ' + response.getMessage() + ' ' + response. > getDetailedMessage()); > return; > } > > var data = response.getDataTable(); > > /////////////////////////// > ////// I am trying to displa the last value of each column > ////////////////////////// > // Create and draw the visualization. > visualization = new google.visualization.Gauge({ > containerId: 'visualization3', > view: {columns: [0,1]} // << I am stuck here! > }); > draw(data); > } > > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/GFQ4_dSGEs4J. 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.
