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/-/E8WBllfq-ysJ.
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.
