I don't know if this is exactly what you are looking for, but it should
work:
google.load('visualization', '1', {packages: ['table']});
function drawVisualization() {
var queryText = encodeURIComponent("SELECT col0, col1, col2 FROM
1361649");
var query = new google.visualization.Query(
'http://www.google.com/fusiontables/gvizdata?tq='+ queryText);
query.send(getData);
}
function getData(response) {
var data = response.getDataTable();
data.addColumn('string', 'foo');
var formatter = new google.visualization.PatternFormat('<a
href="{1}">{0}</a>');
formatter.format(data, [0, 1], 3);
new google.visualization.Table(document.getElementById('visualization'))
.draw(data, {
allowHtml: true,
showRowNumber: false,
alternatingRowStyle: true
});
}
google.setOnLoadCallback(drawVisualization);
You can create a view from 'data' excluding the columns you don't need and
draw the chart using the view if you don't want to see the extra columns.
--
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/-/YGjWPZb6VEcJ.
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.
