Hi Guys, is there a way to link Google Spread sheet files one to each other?.
On Wed, Dec 16, 2009 at 6:16 PM, <[email protected]>wrote: > Today's Topic Summary > > Group: http://groups.google.com/group/google-visualization-api/topics > > - Newb Question: Joining DataTables <#12599fe78086865b_group_thread_0>[2 > Updates] > - Google Gauge - Decimal places? <#12599fe78086865b_group_thread_1> [1 > Update] > - use DateFormat with Annotated Time Line? need > timeZone<#12599fe78086865b_group_thread_2>[1 Update] > - Loading data dynamically using > AnnotatedTimeLine<#12599fe78086865b_group_thread_3>[1 Update] > - How to make an interaction of scatterchart and > linechart<#12599fe78086865b_group_thread_4>[1 Update] > - How to best send data (DataTable and draw-options) to > server..?<#12599fe78086865b_group_thread_5>[2 Updates] > > Topic: Newb Question: Joining > DataTables<http://groups.google.com/group/google-visualization-api/t/1ed5164fbe31c82f> > > Matthew Carroll <[email protected]> Dec 16 09:45AM -0800 > > Cheers Visualizations Crew - > > I feel like a newb asking this question, but I cannot seem to grasp how > to > join DataTables/Views. I know that I am going to get pointed to the API > reference, but I don't the format. > > I am pulling two different queries from different Google Spreadsheets > and > need to join columns from each. I understand the constructor arguments, > but > not the format to actually handle the join of the two tables. > > Can someone please help with some sample code or additional resources > to > help me figure it out? > > Cheers - Matt > > > > > Robert Firicano <[email protected]> Dec 16 12:52PM -0500 > > You need an I'd that is common in both spreadsheets > > > > > On Dec 16, 2009, at 12:45 PM, Matthew Carroll < > [email protected] > > > > Topic: Google Gauge - Decimal > places?<http://groups.google.com/group/google-visualization-api/t/5717eb80f9fbac57> > > NHcoder <[email protected]> Dec 16 09:37AM -0800 > > I'm using the Gauge visualization to display AC current measured to 1 > decimal place. Making the gauge work was easy as I jmultiply my data > value by 10 so that the range is an integer. My issue is with the > displayed value at the bottom of the gauge. That value is displayed > like "218" which is actually "21.8". It would be nice if there was a > configuration option to define the number of decimal places for > display with a default of none. > > > > Topic: use DateFormat with Annotated Time Line? need > timeZone<http://groups.google.com/group/google-visualization-api/t/1f24310bad794d2d> > > Lisa <[email protected]> Dec 16 09:28AM -0800 > > I worked around it by handling all timezone info on the server side, > adjusting as needed when I generate the DataTable. > > > > > > Topic: Loading data dynamically using > AnnotatedTimeLine<http://groups.google.com/group/google-visualization-api/t/a3eb3c9369f310b7> > > Evgeny Fisherov <[email protected]> Dec 16 09:21AM -0800 > > Hello > I sthere any way to update AnnotatedTimeLine instance dynamically and > not in onRender() method? > I need it in order to display dynamically changed information. > > Thank you, > Evgeny > > > > Topic: How to make an interaction of scatterchart and > linechart<http://groups.google.com/group/google-visualization-api/t/264a8e68b4929fe9> > > LaFouine <[email protected]> Dec 16 09:22AM -0800 > > Hello, > > I would like to make an interaction of scatterchart and linechart. > > data1 and data2 are related by Sample ('A','B','C','D'). > > When I click a point of the scatterchart, I want to make highlight the > line of corresponding sample in linechart. > > Is it possible? > > > <html> > <head> > <script type="text/javascript" src="http://www.google.com/jsapi";></ > script> > <script type="text/javascript"> > google.load("visualization", "1", {packages: > ["linechart","scatterchart","Table"]}); > google.setOnLoadCallback(drawChart); > function drawChart() { > // data for scatterchart > var data1 = new google.visualization.DataTable(); > data1.addColumn('number', 'Year'); > data1.addColumn('number', 'Coefficient'); > data1.addColumn('string', 'Sample'); > data1.addRows(4); > data1.setValue(0, 0, 2004); > data1.setValue(0, 1, 12); > data1.setValue(0, 2, 'A'); > data1.setValue(1, 0, 2004); > data1.setValue(1, 1, 5.5); > data1.setValue(1, 2, 'B'); > data1.setValue(2, 0, 2005); > data1.setValue(2, 1, 14); > data1.setValue(2, 2, 'C'); > data1.setValue(3, 0, 2005); > data1.setValue(3, 1, 5); > data1.setValue(3, 2, 'D'); > > > // data for linechart > var data2 = new google.visualization.DataTable(); > data2.addColumn('string', 'Quarter'); > data2.addColumn('number', 'A'); > data2.addColumn('number', 'B'); > data2.addColumn('number', 'C'); > data2.addColumn('number', 'D'); > data2.addRows(4); > data2.setValue(0, 0, '1Q'); > data2.setValue(0, 1, 1000); > data2.setValue(0, 2, 400); > data2.setValue(0, 3, 200); > data2.setValue(0, 4, 300); > data2.setValue(1, 0, '2Q'); > data2.setValue(1, 1, 1170); > data2.setValue(1, 2, 460); > data2.setValue(1, 3, 600); > data2.setValue(1, 4, 300); > data2.setValue(2, 0, '3Q'); > data2.setValue(2, 1, 860); > data2.setValue(2, 2, 580); > data2.setValue(2, 3, 250); > data2.setValue(2, 4, 400); > data2.setValue(3, 0, '4Q'); > data2.setValue(3, 1, 1030); > data2.setValue(3, 2, 540); > data2.setValue(3, 3, 120); > data2.setValue(3, 4, 350); > > var scatterChart = new google.visualization.ScatterChart > (document.getElementById('scatterchart_span')); > scatterChart.draw(data1, {width: 400, height: 240, titleX: > 'Year', titleY: 'Coefficient', legend: 'none', pointSize: 5}); > > var lineChart = new google.visualization.LineChart > (document.getElementById('linechart_span')); > lineChart.draw(data2, {width: 400, height: 240, legend: > 'bottom', titleX: 'Quarter', titleY: 'Sales'}); > > /* > ??? How to relate scatterchart to linechart ??? > google.visualization.events.addListener(scatterChart, > 'select', function() { > lineChart.setSelection(scatterChart.getSelection()); > }); > */ > > > //For easy to see data > var table1 = new google.visualization.Table > (document.getElementById('table1_div')); > table1.draw(data1, {showRowNumber: true}); > > var table2 = new google.visualization.Table > (document.getElementById('table2_div')); > table2.draw(data2, {showRowNumber: true}); > } > </script> > </head> > > <body> > <span id="scatterchart_span"></span> > <span id="linechart_span"></span> > <H3>data</H3> > <div id='table1_div'></div> > <p> > <div id='table2_div'></div> > </body> > </html> > > > > Topic: How to best send data (DataTable and draw-options) to > server..?<http://groups.google.com/group/google-visualization-api/t/fd979f2e196291e0> > > codingGirl <[email protected]> Dec 16 07:51AM -0800 > > Nobody can at least give a hint how to do this? > > > > > Markw65 <[email protected]> Dec 16 08:28AM -0800 > > Well, actually, encoding the data in the url is /exactly/ how the > image charts work. > > And yes, it does mean that the url length is limited - eg ie6 limits > it to 2k on the client side. Also, some servers will limit it > (although I dont think google's chart servers do that). > > If you want/need to get around that, you can use "POST" instead of > "GET" with an XMLHttpRequest from javascript. Then you can send > whatever (and however much) data you want. > > But then you're outside of the google visualization world, and are > working with your own protocol. > > Mark > > > > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]<google-visualization-api%[email protected]> > . > 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
