[visualization-api] Re: Simple Dashboard taking data from google sheets - One or more participants failed to draw

Wed, 13 Jan 2016 22:39:02 -0800 

Hey, I'm having similar problem. Can anyone please help me out about why my 
code isn't working.

Here's my code.


 <script type="text/javascript" src="https://www.google.com/jsapi";></script>
        <script type="text/javascript">
            google.load('visualization', '1.0', {'packages': ['table', 
'controls', 'bar']});
            google.setOnLoadCallback(queryData);  
            
            function queryData() {
                var queryString = encodeURIComponent('SELECT A,B');
                var magicIncantation = 
'/gviz/tq?gid=701198084&headers=1&tq=';
                var query = new 
google.visualization.Query('https://docs.google.com/spreadsheets/d/12hTDGf-hHtLoqns1Tg63Dly2w7cEfkbqU_P6zVXyy28/'
 
+ magicIncantation + queryString);
                query.send(handleQueryResponse);
            };
            
            
            function handleQueryResponse(response) {
              var data = response.getDataTable();
              var dashboard = new google.visualization.Dashboard(
                document.getElementById('dashboard_div'));

              var chartRangeFilter = new 
google.visualization.ControlWrapper({
                'controlType': 'CategoryFilter',
                'containerId': 'control_div',
                'options': {
                  'filterColumnIndex': 1
                }
              });

              var barChart = new google.visualization.ChartWrapper({
                'chartType': 'Table',
                'containerId': 'chart_div'
              });

              dashboard.bind(chartRangeFilter, barChart);
              dashboard.draw(data);
            };

        </script>


I followed the JS Fiddle fixed example. But my dashboard doesn't populate 
the chart.
Please help me out.


On Thursday, January 7, 2016 at 7:01:35 PM UTC+5:30, 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/72cb5b8c-6238-464c-94e4-4fc7712b3b65%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to