[visualization-api] Chart doesn't appear when dynamically adding to div via jQuery
Hello, I am trying to use the API to create an interactive pie chart based on a user's form selections. jQuery is used to update the div upon a selection change. I used to use a simple image from the google charts API, and this worked perfectly. But now that I have modified the code to put javascript in the div, the div reloads empty. When I run the javascript on its own in a separate file, it works fine, just not when trying to refresh through jquery. Here are the last 2 lines of the javascript to produce the chart ('leadchart' is the id of the div tag to print to): var chart = new google.visualization.PieChart(document.getElementById('leadchart')); chart.draw(data, {width: 400, height: 240, is3D: true, title: 'Lead Graph'}); Here is my jQuery function to handle when the form selection is changed: $(#dateRange).change(function(){ $.get(/includes/get_chart.php, { dateRange: $ (#dateRange).val() }, function(data){ $(#leadchart).html(data); }); }); Anyone know how to get this able to refresh dynamically? Thanks in advance! -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
[visualization-api] Error
Hello, I am working on charts which is display with the help of google Visualization Api. The problem is , My code is working correctly but while displaying chart in Internet Explorer I am getting Error : Stop running this Script ? A Script on this page is causing Internet Explorer to run Slowly. If it continues to run, your computer might become unresponsive. I am getting this massage on alter box where i need to click on No button till it display chart on page . After some time it shows me chart. please give me solution for this error. So ,i ll not get this massage while running script and also tel me is there is any way to display chart using Database values? I there is no way then tel mi how can i transfer database table values in google spreadsheet. Please reply -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
Re: [visualization-api] Intensity Map data format problem
Hi. You can either do the translate yourself or consider using the Geo Maphttp://code.google.com/apis/visualization/documentation/gallery/geomap.htmlwhich can get the country name and not only the ISO code. Best, Viz Kid On Mon, Mar 15, 2010 at 11:07 PM, Amer tipsc...@gmail.com wrote: Hello! Iam trying to display the traffic sources (countries) of a website. The dimension 'ga:country' returns countries by their names not their ISO codes. So how can i convert the country name i receive from the data feed into its ISO code so as for the Intensity Map DataTable to be compatible with ? plz help! -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.comgoogle-visualization-api%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en. -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
Re: [visualization-api] [GEOMAP]
Hi. Unfortunately these are the only maps we supply at the moment. Best, Viz Kid On Tue, Mar 16, 2010 at 4:05 PM, Marcel Overdijk marceloverd...@gmail.comwrote: When I'm displaying Netherlands (NL) in geomap part of the visualization is also it's neighbouring countries like Belgium and Germany. In the case of the Netherlands Germany is quite a big part of the image. Would it be possible to leave out the neigbouring countries? In only want to display the Netherlands in the map. -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.comgoogle-visualization-api%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en. -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
Re: [visualization-api] Custom text in tooltip for piechart
Hi. The first two lines of the tooltip are fully customizable by setting the formatted value of the first and two columns (you can also use new line characters to split the lines if you need more). The last line will always be the percentages and this cannot be changed. Hope this helps, Viz Kid On Tue, Mar 16, 2010 at 6:08 PM, Books srikanthr...@gmail.com wrote: I want to have my own text inside the tooltip that shows up on clicking of slices of pie chart. How can I achieve that? I am stuck up in here, Your help is highly appreciable. -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.comgoogle-visualization-api%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en. -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
Re: [visualization-api] creating hyperlinks in interactive line chart using google api
This is currently not supported, sorry. Best, Viz Kid On Tue, Mar 16, 2010 at 11:04 AM, plf plf...@gmail.com wrote: Hi, Is it possible to link x-axis labels in interactive line chart to urls so that they are hyperlinks using google API ? If yes how do I go about it ? Thank you. -plf -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.comgoogle-visualization-api%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en. -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
Re: [visualization-api] Re: Data Table join issue.
Hi. First, you should probably remove the () in the last line where you set the on load callback. Second, as specified in the documentationhttp://code.google.com/apis/visualization/documentation/reference.html#google_visualization_data_joinof the join method, the fourth parameter should be an array of pairs of columns indices to compare. Therefore, I assume you must have meant to use [[0,1]] and not [0,1]. Hope this helps, Viz Kid On Fri, Mar 19, 2010 at 3:36 AM, Pegasusrjf pegasus...@gmail.com wrote: Hello. No-one has any ideas here? On Mar 17, 9:13 pm, Pegasusrjf pegasus...@gmail.com wrote: I am using the code below to try an join two DataTables together. I keep getting this error: Error: Invalid column index undefined. Should be an integer in the range [0-13]. The first table referenced has 14 columns, and the second table has 3 columns. No matter what I try I can't get it to display the data. I am lost as I can enter commands in the debugger and see that the data does exist for different columns. Any help is greatly appreciated. Code below... script type=text/javascript var visualization; var mDriverName; var mResultDetails; var mDataJoin; function drvDataVisualization() { var qDrvName = new google.visualization.Query('http:// spreadsheets.google.com/pub? key=tFijkSiJElqcqvWczlkYGfAheaders=1gid=1'); // Apply query language. qDrvName.setQuery('SELECT *'); // Send the query with a callback function. qDrvName.send(drvDataResponse); } function drvDataResponse(response) { if (response.isError()) { alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage()); return; } mDriverName = response.getDataTable(); var qRdetails = new google.visualization.Query('http:// spreadsheets.google.com/pub? key=tFijkSiJElqcqvWczlkYGfAheaders=1gid=5'); // Apply query language. qRdetails.setQuery('SELECT *'); // Send the query with a callback function. qRdetails.send(rDetailQueryResponse); } function rDetailQueryResponse(response) { if (response.isError()) { alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage()); return; } mResultDetails = response.getDataTable(); mDataJoin = new google.visualization.data.join(mResultDetails,mDriverName,'inner', [1,0],[2,5,6,7,8],[1]); var mDrawData = new google.visualization.Table(document.getElementById('dvrDetails')); mDrawData.Draw(mDataJoin,null); } google.setOnLoadCallback(drvDataVisualization()); /script -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.comgoogle-visualization-api%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en. -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
Re: [visualization-api] Reverse Y-axis in AreaChart
Not at the moment. Best, Viz Kid On Thu, Mar 18, 2010 at 8:21 PM, Andrew Eames andrewea...@google.comwrote: Is there a way to reverse the Y-axis in an AreaChart? Thanks -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.comgoogle-visualization-api%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en. -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
Re: [visualization-api] Annotated Timeline - More than one annotation per data point??
Hi. Unfortunately this is currently not supported in the Annotated Time Line of the Google Visualization API. Best, Viz Kid On Fri, Mar 19, 2010 at 7:39 AM, Lukey B luke.b.by...@gmail.com wrote: Hi there, I cannot see in the docs how this done. I want to be able to add more than 1 annotation per data point, similar to what is done on the annotated timeline used in the Google Finance site. Any suggestions most welcome. Cheers, LB -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.comgoogle-visualization-api%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en. -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
[visualization-api] Re: Data Table join issue.
I didn't relaize I needed an array of pairs, as I was using what I saw in the interactive code samples and it didn't show that. What I really want to display is multiple columns from table 1 and one column from table 2. How could I go about this? On Mar 19, 10:09 am, Viz Kid viz...@google.com wrote: Hi. First, you should probably remove the () in the last line where you set the on load callback. Second, as specified in the documentationhttp://code.google.com/apis/visualization/documentation/reference.htm...of the join method, the fourth parameter should be an array of pairs of columns indices to compare. Therefore, I assume you must have meant to use [[0,1]] and not [0,1]. Hope this helps, Viz Kid On Fri, Mar 19, 2010 at 3:36 AM, Pegasusrjf pegasus...@gmail.com wrote: Hello. No-one has any ideas here? On Mar 17, 9:13 pm, Pegasusrjf pegasus...@gmail.com wrote: I am using the code below to try an join two DataTables together. I keep getting this error: Error: Invalid column index undefined. Should be an integer in the range [0-13]. The first table referenced has 14 columns, and the second table has 3 columns. No matter what I try I can't get it to display the data. I am lost as I can enter commands in the debugger and see that the data does exist for different columns. Any help is greatly appreciated. Code below... script type=text/javascript var visualization; var mDriverName; var mResultDetails; var mDataJoin; function drvDataVisualization() { var qDrvName = new google.visualization.Query('http:// spreadsheets.google.com/pub? key=tFijkSiJElqcqvWczlkYGfAheaders=1gid=1'); // Apply query language. qDrvName.setQuery('SELECT *'); // Send the query with a callback function. qDrvName.send(drvDataResponse); } function drvDataResponse(response) { if (response.isError()) { alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage()); return; } mDriverName = response.getDataTable(); var qRdetails = new google.visualization.Query('http:// spreadsheets.google.com/pub? key=tFijkSiJElqcqvWczlkYGfAheaders=1gid=5'); // Apply query language. qRdetails.setQuery('SELECT *'); // Send the query with a callback function. qRdetails.send(rDetailQueryResponse); } function rDetailQueryResponse(response) { if (response.isError()) { alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage()); return; } mResultDetails = response.getDataTable(); mDataJoin = new google.visualization.data.join(mResultDetails,mDriverName,'inner', [1,0],[2,5,6,7,8],[1]); var mDrawData = new google.visualization.Table(document.getElementById('dvrDetails')); mDrawData.Draw(mDataJoin,null); } google.setOnLoadCallback(drvDataVisualization()); /script -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.comgoogle-visualization-api%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.- Hide quoted text - - Show quoted text - -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
[visualization-api] Re: Data Table join issue.
I think I get it now. So if I want column 0 of table one to match again column 1 of table two it would be as follows: [[0],[1]] On Mar 19, 10:09 am, Viz Kid viz...@google.com wrote: Hi. First, you should probably remove the () in the last line where you set the on load callback. Second, as specified in the documentationhttp://code.google.com/apis/visualization/documentation/reference.htm...of the join method, the fourth parameter should be an array of pairs of columns indices to compare. Therefore, I assume you must have meant to use [[0,1]] and not [0,1]. Hope this helps, Viz Kid On Fri, Mar 19, 2010 at 3:36 AM, Pegasusrjf pegasus...@gmail.com wrote: Hello. No-one has any ideas here? On Mar 17, 9:13 pm, Pegasusrjf pegasus...@gmail.com wrote: I am using the code below to try an join two DataTables together. I keep getting this error: Error: Invalid column index undefined. Should be an integer in the range [0-13]. The first table referenced has 14 columns, and the second table has 3 columns. No matter what I try I can't get it to display the data. I am lost as I can enter commands in the debugger and see that the data does exist for different columns. Any help is greatly appreciated. Code below... script type=text/javascript var visualization; var mDriverName; var mResultDetails; var mDataJoin; function drvDataVisualization() { var qDrvName = new google.visualization.Query('http:// spreadsheets.google.com/pub? key=tFijkSiJElqcqvWczlkYGfAheaders=1gid=1'); // Apply query language. qDrvName.setQuery('SELECT *'); // Send the query with a callback function. qDrvName.send(drvDataResponse); } function drvDataResponse(response) { if (response.isError()) { alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage()); return; } mDriverName = response.getDataTable(); var qRdetails = new google.visualization.Query('http:// spreadsheets.google.com/pub? key=tFijkSiJElqcqvWczlkYGfAheaders=1gid=5'); // Apply query language. qRdetails.setQuery('SELECT *'); // Send the query with a callback function. qRdetails.send(rDetailQueryResponse); } function rDetailQueryResponse(response) { if (response.isError()) { alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage()); return; } mResultDetails = response.getDataTable(); mDataJoin = new google.visualization.data.join(mResultDetails,mDriverName,'inner', [1,0],[2,5,6,7,8],[1]); var mDrawData = new google.visualization.Table(document.getElementById('dvrDetails')); mDrawData.Draw(mDataJoin,null); } google.setOnLoadCallback(drvDataVisualization()); /script -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.comgoogle-visualization-api%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.- Hide quoted text - - Show quoted text - -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
Re: [visualization-api] Chart doesn't appear when dynamically adding to div via jQuery
Hi. I'm not sure what you meant to do with the function to handle the jQuery. When you want the chart to appear, you should have a visible div and afterwards run the two rows that you wrote here to actually draw it. Nothing else is needed (the inner html of the div will dynamically be updated to the chart). If this still doesn't work, please try to be more specific in the description of what is the timeline of your code. Hope this helps, Viz Kid On Fri, Mar 19, 2010 at 8:00 AM, mkb5150 mkb5...@gmail.com wrote: Hello, I am trying to use the API to create an interactive pie chart based on a user's form selections. jQuery is used to update the div upon a selection change. I used to use a simple image from the google charts API, and this worked perfectly. But now that I have modified the code to put javascript in the div, the div reloads empty. When I run the javascript on its own in a separate file, it works fine, just not when trying to refresh through jquery. Here are the last 2 lines of the javascript to produce the chart ('leadchart' is the id of the div tag to print to): var chart = new google.visualization.PieChart(document.getElementById('leadchart')); chart.draw(data, {width: 400, height: 240, is3D: true, title: 'Lead Graph'}); Here is my jQuery function to handle when the form selection is changed: $(#dateRange).change(function(){ $.get(/includes/get_chart.php, { dateRange: $ (#dateRange).val() }, function(data){ $(#leadchart).html(data); }); }); Anyone know how to get this able to refresh dynamically? Thanks in advance! -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.comgoogle-visualization-api%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en. -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
Re: [visualization-api] Error
Hi. Some visualization perform more javascript computations than others, depending on the size of the data you provide. Internet explorer renders the javascript slower and possibly have a shorted waiting period. You can try and set it to wait longer before showing this message. Also, if the data is indeed very big, maybe you can use smaller data table or split it into several different visualizations. As for your second question, it depends on what database you have. There are other groups which can help you in uploading data into Google Spreadsheets. Best, Viz Kid On Fri, Mar 19, 2010 at 2:30 PM, sheetal. ranihpa...@gmail.com wrote: Hello, I am working on charts which is display with the help of google Visualization Api. The problem is , My code is working correctly but while displaying chart in Internet Explorer I am getting Error : Stop running this Script ? A Script on this page is causing Internet Explorer to run Slowly. If it continues to run, your computer might become unresponsive. I am getting this massage on alter box where i need to click on No button till it display chart on page . After some time it shows me chart. please give me solution for this error. So ,i ll not get this massage while running script and also tel me is there is any way to display chart using Database values? I there is no way then tel mi how can i transfer database table values in google spreadsheet. Please reply -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.comgoogle-visualization-api%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en. -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
[visualization-api] Re: Error
Hello Viz Kid! Iam facing the same problem even though iam using small amount of data of 1 website for a period of 1 month! My code is working properly on FireFox. It is not working on IE8 or Chrome! Could you please help? Thanks! On Mar 19, 4:22 pm, Viz Kid viz...@google.com wrote: Hi. Some visualization perform more javascript computations than others, depending on the size of the data you provide. Internet explorer renders the javascript slower and possibly have a shorted waiting period. You can try and set it to wait longer before showing this message. Also, if the data is indeed very big, maybe you can use smaller data table or split it into several different visualizations. As for your second question, it depends on what database you have. There are other groups which can help you in uploading data into Google Spreadsheets. Best, Viz Kid On Fri, Mar 19, 2010 at 2:30 PM, sheetal. ranihpa...@gmail.com wrote: Hello, I am working on charts which is display with the help of google Visualization Api. The problem is , My code is working correctly but while displaying chart in Internet Explorer I am getting Error : Stop running this Script ? A Script on this page is causing Internet Explorer to run Slowly. If it continues to run, your computer might become unresponsive. I am getting this massage on alter box where i need to click on No button till it display chart on page . After some time it shows me chart. please give me solution for this error. So ,i ll not get this massage while running script and also tel me is there is any way to display chart using Database values? I there is no way then tel mi how can i transfer database table values in google spreadsheet. Please reply -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.comgoogle-visualization- api%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en. -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
[visualization-api] Re: Data Table join issue.
Thank you very much Viz-Kid. I got it working. 2nd Question. Can I now query for another table and then join it to the first joined table? On Mar 19, 10:16 am, Pegasusrjf pegasus...@gmail.com wrote: I think I get it now. So if I want column 0 of table one to match again column 1 of table two it would be as follows: [[0],[1]] On Mar 19, 10:09 am, Viz Kid viz...@google.com wrote: Hi. First, you should probably remove the () in the last line where you set the on load callback. Second, as specified in the documentationhttp://code.google.com/apis/visualization/documentation/reference.htm...of the join method, the fourth parameter should be an array of pairs of columns indices to compare. Therefore, I assume you must have meant to use [[0,1]] and not [0,1]. Hope this helps, Viz Kid On Fri, Mar 19, 2010 at 3:36 AM, Pegasusrjf pegasus...@gmail.com wrote: Hello. No-one has any ideas here? On Mar 17, 9:13 pm, Pegasusrjf pegasus...@gmail.com wrote: I am using the code below to try an join two DataTables together. I keep getting this error: Error: Invalid column index undefined. Should be an integer in the range [0-13]. The first table referenced has 14 columns, and the second table has 3 columns. No matter what I try I can't get it to display the data. I am lost as I can enter commands in the debugger and see that the data does exist for different columns. Any help is greatly appreciated. Code below... script type=text/javascript var visualization; var mDriverName; var mResultDetails; var mDataJoin; function drvDataVisualization() { var qDrvName = new google.visualization.Query('http:// spreadsheets.google.com/pub? key=tFijkSiJElqcqvWczlkYGfAheaders=1gid=1'); // Apply query language. qDrvName.setQuery('SELECT *'); // Send the query with a callback function. qDrvName.send(drvDataResponse); } function drvDataResponse(response) { if (response.isError()) { alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage()); return; } mDriverName = response.getDataTable(); var qRdetails = new google.visualization.Query('http:// spreadsheets.google.com/pub? key=tFijkSiJElqcqvWczlkYGfAheaders=1gid=5'); // Apply query language. qRdetails.setQuery('SELECT *'); // Send the query with a callback function. qRdetails.send(rDetailQueryResponse); } function rDetailQueryResponse(response) { if (response.isError()) { alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage()); return; } mResultDetails = response.getDataTable(); mDataJoin = new google.visualization.data.join(mResultDetails,mDriverName,'inner', [1,0],[2,5,6,7,8],[1]); var mDrawData = new google.visualization.Table(document.getElementById('dvrDetails')); mDrawData.Draw(mDataJoin,null); } google.setOnLoadCallback(drvDataVisualization()); /script -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.comgoogle-visualization- api%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.-Hide quoted text - - Show quoted text - -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
Re: [visualization-api] Re: Error
It would be more useful if you could specify some more information such as: - What visualization are you using? - What is the size of the data table? If you can send us a url of a live example it would be great. Viz Kid On Fri, Mar 19, 2010 at 4:57 PM, Amer tipsc...@gmail.com wrote: Hello Viz Kid! Iam facing the same problem even though iam using small amount of data of 1 website for a period of 1 month! My code is working properly on FireFox. It is not working on IE8 or Chrome! Could you please help? Thanks! On Mar 19, 4:22 pm, Viz Kid viz...@google.com wrote: Hi. Some visualization perform more javascript computations than others, depending on the size of the data you provide. Internet explorer renders the javascript slower and possibly have a shorted waiting period. You can try and set it to wait longer before showing this message. Also, if the data is indeed very big, maybe you can use smaller data table or split it into several different visualizations. As for your second question, it depends on what database you have. There are other groups which can help you in uploading data into Google Spreadsheets. Best, Viz Kid On Fri, Mar 19, 2010 at 2:30 PM, sheetal. ranihpa...@gmail.com wrote: Hello, I am working on charts which is display with the help of google Visualization Api. The problem is , My code is working correctly but while displaying chart in Internet Explorer I am getting Error : Stop running this Script ? A Script on this page is causing Internet Explorer to run Slowly. If it continues to run, your computer might become unresponsive. I am getting this massage on alter box where i need to click on No button till it display chart on page . After some time it shows me chart. please give me solution for this error. So ,i ll not get this massage while running script and also tel me is there is any way to display chart using Database values? I there is no way then tel mi how can i transfer database table values in google spreadsheet. Please reply -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.comgoogle-visualization-api%2bunsubscr...@googlegroups.comgoogle-visualization- api%2bunsubscr...@googlegroups.com api%252bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en. -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.comgoogle-visualization-api%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en. -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
Re: [visualization-api] Re: Data Table join issue.
Yes. The joined data table is just like any other DataTable and you can join it with another table. Viz Kid On Fri, Mar 19, 2010 at 6:55 PM, Pegasusrjf pegasus...@gmail.com wrote: Thank you very much Viz-Kid. I got it working. 2nd Question. Can I now query for another table and then join it to the first joined table? On Mar 19, 10:16 am, Pegasusrjf pegasus...@gmail.com wrote: I think I get it now. So if I want column 0 of table one to match again column 1 of table two it would be as follows: [[0],[1]] On Mar 19, 10:09 am, Viz Kid viz...@google.com wrote: Hi. First, you should probably remove the () in the last line where you set the on load callback. Second, as specified in the documentation http://code.google.com/apis/visualization/documentation/reference.htm.. .of the join method, the fourth parameter should be an array of pairs of columns indices to compare. Therefore, I assume you must have meant to use [[0,1]] and not [0,1]. Hope this helps, Viz Kid On Fri, Mar 19, 2010 at 3:36 AM, Pegasusrjf pegasus...@gmail.com wrote: Hello. No-one has any ideas here? On Mar 17, 9:13 pm, Pegasusrjf pegasus...@gmail.com wrote: I am using the code below to try an join two DataTables together. I keep getting this error: Error: Invalid column index undefined. Should be an integer in the range [0-13]. The first table referenced has 14 columns, and the second table has 3 columns. No matter what I try I can't get it to display the data. I am lost as I can enter commands in the debugger and see that the data does exist for different columns. Any help is greatly appreciated. Code below... script type=text/javascript var visualization; var mDriverName; var mResultDetails; var mDataJoin; function drvDataVisualization() { var qDrvName = new google.visualization.Query('http:// spreadsheets.google.com/pub? key=tFijkSiJElqcqvWczlkYGfAheaders=1gid=1'); // Apply query language. qDrvName.setQuery('SELECT *'); // Send the query with a callback function. qDrvName.send(drvDataResponse); } function drvDataResponse(response) { if (response.isError()) { alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage()); return; } mDriverName = response.getDataTable(); var qRdetails = new google.visualization.Query('http:// spreadsheets.google.com/pub? key=tFijkSiJElqcqvWczlkYGfAheaders=1gid=5'); // Apply query language. qRdetails.setQuery('SELECT *'); // Send the query with a callback function. qRdetails.send(rDetailQueryResponse); } function rDetailQueryResponse(response) { if (response.isError()) { alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage()); return; } mResultDetails = response.getDataTable(); mDataJoin = new google.visualization.data.join(mResultDetails,mDriverName,'inner', [1,0],[2,5,6,7,8],[1]); var mDrawData = new google.visualization.Table(document.getElementById('dvrDetails')); mDrawData.Draw(mDataJoin,null); } google.setOnLoadCallback(drvDataVisualization()); /script -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.comgoogle-visualization-api%2bunsubscr...@googlegroups.comgoogle-visualization- api%2bunsubscr...@googlegroups.com api%252bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.-Hidequoted text - - Show quoted text - -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from
[visualization-api] Re: Creating a Motion Chart with Google Spreadsheets as a data source
Hi, Thank you for the advice, much appreciated. Regards, Matt On Mar 19, 12:43 pm, robinhowlett robin.howl...@gmail.com wrote: Your code is all over the place and doesn't make sense. JavaScript variable declarations have function-scope. You can't declare the variable 'query' inside drawVisualization() and then try to use it outside the function. And you are trying to use 'data' without even declaring it or assigning anything to it. You also seem to trying to create two Motion Charts - I can't figure out why. Lastly, you have to read the Visualization API documentation; look at the docs for Query Language and the google.visualization.Query reference. In your code you are trying to use a published spreadsheet page in HTML format as the Query source - you don't do that. Use the raw Spreadsheet data itself by pointing to the URL of the spreadsheet. The Data Source Request example mentioned below will show you how. What you are trying to do is quite simple. Rather than just giving you the solution, you should be able to figure it out by: Go to the Google Code Playground and look at i) the HTML view of Visualization Data Source Requests Data Source Requests -http://code.google.com/apis/ajax/playground/#data_source_request ii) replace the IntensityMap instantiation with MotionChart (it's in your sample but also in Visualization Basic Motion Charts -http://code.google.com/apis/ajax/playground/#motion_chart) On Mar 17, 3:16 pm, Matt matthewstewar...@gmail.com wrote: Hi everyone, I am trying to build a motion chart visualization that uses Google Spreadsheets as a data source. I have pasted my code below. Could anyone make any suggestions on how to make it display properly? Thanks! Regards, Matt !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Strict//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd; html xmlns=http://www.w3.org/1999/xhtml; head meta http-equiv=content-type content=text/html; charset=utf-8/ title Google Visualization API Sample /title script type=text/javascript src=http://www.google.com/jsapi;/ script script type=text/javascript google.load('visualization', '1', {packages: ['motionchart']}); /script script type=text/javascript var visualization; function drawVisualization() { // To see the data that this visualization uses, browse to //http://spreadsheets.google.com/ccc?key=pCQbetd-CptGXxxQIG7VFIQ var query = new google.visualization.Query( 'http://spreadsheets.google.com/pub?key=taExbkdYGXKWoQ- BzwFPYtwoutput=html'); var motionchart = new google.visualization.MotionChart( document.getElementById('visualization')); motionchart.draw(data, {'width': 800, 'height': 400}); } google.setOnLoadCallback(drawVisualization); // Send the query with a callback function. query.send(handleQueryResponse); function handleQueryResponse(response) { if (response.isError()) { alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage()); return; } var motionchart = new google.visualization.MotionChart( document.getElementById('visualization')); motionchart.draw(data, {'width': 800, 'height': 400}); } google.setOnLoadCallback(drawVisualization); //} /script /head body style=font-family: Arial;border: 0 none; div id=visualization style=height: 400px; width: 400px;/ div /body /html -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
[visualization-api] Re: No Offline Use, no Use at All
I agree... GOOGLE HELP US!!! On Mar 13, 9:20 am, chalu chal...@gmail.com wrote: giving GWT Visualization and Google Visualizations such a restrictive use terms is the dumbest ever to come from Google, what were the reasons for this by the way, I don't see the point at all. I support an offline option. On Mar 11, 3:49 pm, Paulo Marquez paulo.marq...@gmail.com wrote: I second the motion!, it's simply logical. Regards Paulo Márquez On Thu, Mar 11, 2010 at 6:19 AM, Nico R. nico.roga...@gmail.com wrote: Hi all, @Google Vis Team, but also for comments and supports @All Now seriously! How do you want to establish GWT in Enterprise Development if you put a very interesting part under such senseless use terms like the ones from GWT Visualization? I just spend 3 days of work on a enterprise wide intranet application to integrate Visualization Charts, just to realize in the end that GWT Vis is not usable without an internet connection. Unfortunately not every company has such free internet using policies as I imagine them in your company, so the Vis Package is totally useless for Intranet applications. Make GWT Visualization offline available! (Please) regards Nico R. -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.comgoogle-visualization-api%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en. -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To post to this group, send email to google-visualization-...@googlegroups.com. To unsubscribe from this group, send email to google-visualization-api+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.