This is the complete code of I am using to draw a motion chart from a Google spreadsheet. I have ensured I format each of the data column to a format that meet the motion chart design. However, I am still getting an error message that reads *"Error in Query:Request Timed Out."* The boldened "*tq?&range=A1:S200" *on the spreadsheet URL is what I added to specify the range of the query. The B column, as shown in the query.setQuery ( ) is the date column. What am I doing wrong? Thanks
<script type="text/javascript" src="https://www.google.com/jsapi";></script> <script type="text/javascript"> google.load("visualization", "1", {packages:["motionchart"]}); google.setOnLoadCallback(drawChart); function drawChart() { var query = new google.visualization.Query('https://docs.google.com/spreadsheets/d/1uAhJGszTwtxx1JuolQQJ0DhzQ48z2yE7lv0EeHcIHVI/pubhtml *tq?&range=A1:S200*'); query.setQuery("SELECT A, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q, R, S WHERE B >= date '2009/0/2' and B <= date '2013/0/9' ORDER BY B"); query.send(handleQueryResponse); } function handleQueryResponse(response) { if (response.isError()) { alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage()); return; } var data = response.getDataTable(); var chart = new google.visualization.MotionChart(document.getElementById('scatter')); var options = {}; options['state'] = chart.draw(data, {width: 900, height:400}); '{"colorOption":"4","iconKeySettings":[],"nonSelectedAlpha":0.4,"orderedByX":false,"iconType":"BUBBLE","yAxisOption":"3","uniColorForNonSelected":false,"yZoomedDataMin":150,"dimensions":{"iconDimensions":["dim0"]},"orderedByY":false,"xZoomedIn":false,"yZoomedDataMax":617,"duration":{"multiplier":1,"timeUnit":"D"},"showTrails":true,"xAxisOption":"2","xZoomedDataMax":1200,"time":"1988","xZoomedDataMin":300,"playDuration":15000,"yLambda":1,"sizeOption":"_UNISIZE","yZoomedIn":false,"xLambda":1};'; options['width'] = 900; options['height'] = 400; } </script> -- 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 http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
