Code I'm using..
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<script type="text/javascript"
src="https://www.google.com/jsapi";></script>
<script type="text/javascript">
google.load('visualization', '1.0', {'packages':['controls','bar']});
google.setOnLoadCallback(queryData);
function queryData(){
var queryString = encodeURIComponent('SELECT A,B,C');
var magicIncantation = '/gviz/tq?gid=0&headers=1&tq=';
var query = new
google.visualization.Query('https://docs.google.com/spreadsheets/d/1aZZuEu78G2ZU49Gq41yaWhzRJkvEbXRxoc8mnTWva2s/'
+ magicIncantation + queryString);
query.send(handleQueryResponse);
};
function handleQueryResponse(response){
var data = response.getDataTable();
var dashboard = new
google.visualization.Dashboard(document.getElementById('dashboard_div'));
ChartRangeFilter = new google.visualization.ControlWrapper({
'controlType': 'CategoryFilter',
'containerId': 'control_ div',
'options': {
'filterColumnIndex': 0,
},
});
BarChart = new google.visualization.ChartWrapper({
'chartType':'TableChart',
'containerID': 'chart_div',
});
dashboard.bind(ChartRangeFilter,BarChart);
dashboard.draw(data);
};
</script>
</head>
<body>
<div id='dashboard_div'>
<div id='chart_div'</div>
<div id = 'control_div'></div>
</div>
</body>
</html>
On Thursday, January 7, 2016 at 1:31:35 PM UTC, Gareth R wrote:
>
> Hi, I'm new to this and trying to create a simple dashboard using taking a
> simple table from Google sheets, to enable me to create a template that i
> can them expand on for further learning. I can get the table to show as a
> simple table using charts but not in the form of a dashboard, I get the
> above error. Any help for a newbie appreciated.
>
> Many thanks,
> Gareth
>
>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-visualization-api/3de8061c-016b-4700-8689-044f4414c798%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
