Ayobami, If that is actually what you added, the notation is not quite correct. See the documentation on https://devsite.googleplex.com/chart/interactive/docs/querylanguage and note that you need to add "/gviz/tq?tq=..." before your query.
On Mon, Jun 15, 2015 at 10:51 PM, Ayobami Akanmu <[email protected]> wrote: > > 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. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> - 978-394-1058 [email protected] <[email protected]> 5CC, Cambridge MA [email protected] <[email protected]> 9 Juniper Ridge Road, Acton MA -- 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.
