Thank you so much for the solution for bar chart. Also i would like to directly export table data to excel/csv. I dont want to use/store data using google spreadsheet here.
Is there any way to do this? Any help is much appreciated. On Wednesday, July 18, 2012 9:52:50 PM UTC+5:30, asgallant wrote: > > There were a couple of things here that needed fixing: > > 1) you are trying to use the BarChart class without loading the corechart > package; switching to a ChartWrapper fixes the problem (as would loading > "corecharts" alongside "controls" if you would prefer that way). > 2) the data_geo dataTable needs to have its columns defined outside the > 'ready' event handler (otherwise, every time someone moves the sliders, it > will add new columns to the DataTable, and will throw an error > > It's also better to define the bar chart outside the 'ready' event > handler, as otherwise you will be creating new chart objects every time. > See implementation here: http://jsfiddle.net/asgallant/MqERY/1/ > > On Wednesday, July 18, 2012 6:22:19 AM UTC-4, Priyanka wrote: >> >> In the same example (PFA html file), i have calculated geomean values for >> 3 coulms and now i am trying to draw a bar chart for the calculated geomean >> values dynamicaly. >> >> For this i have created a new DataTable 'data_geo' and i have added >> calulated geomean values to it using data_geo.setcell . Now when i am using >> draw() for data_geo but i am not able to draw a bar chart. Also i need to >> export the table values to excel on button click. >> >> Can someone please help? >> >> Thanks for your time! >> >> On Thursday, July 12, 2012 10:49:15 PM UTC+5:30, Priyanka wrote: >>> >>> i was actually trying out on a hosted server. Later I have copied the >>> file tried to open in the browser locally using windows path and found that >>> it was fast. >>> Hence the slowness issue that i was seeing, should be purely because of >>> server speed and not related to the code. >>> >>> Thanks for the help :) >>> >>> On Thu, Jul 12, 2012 at 10:18 PM, asgallant >>> <[email protected]>wrote: >>> >>>> I ran the script you posted through FF, Chrome, IE 8, and IE 9 and >>>> didn't see any performance problems. >>>> >>>> >>>> On Thursday, July 12, 2012 2:43:42 AM UTC-4, kp wrote: >>>>> >>>>> Thanks a lot for the solution that you have provided with examples. >>>>> It worked out well. >>>>> >>>>> One small issue that i am seeing here is the there is delay >>>>> in the display of average and geomean values after any of the selection >>>>> criteria is changed. Any idea to make this faster? I don't see this in >>>>> the >>>>> example that you have sent. >>>>> >>>>> >>>>> On Wed, Jul 11, 2012 at 9:17 PM, asgallant >>>>> <[email protected]>wrote: >>>>> >>>>>> This is fairly easy to do. Set up a 'ready' event handler for the >>>>>> Table that gets the DataTable used by the Table, and then group on this >>>>>> data to get the average and geometric mean of the data. See an example >>>>>> here: >>>>>> http://jsfiddle.net/asgallant/**rEhUp/<http://jsfiddle.net/asgallant/rEhUp/> >>>>>> >>>>>> >>>>>> If you don't want to show the charts, then you can drop all but one >>>>>> from the visualization, and hide the div that the last one resides in. >>>>>> See >>>>>> example here: >>>>>> http://jsfiddle.net/asgallant/**rEhUp/1/<http://jsfiddle.net/asgallant/rEhUp/1/> >>>>>> >>>>>> >>>>>> >>>>>> On Wednesday, July 11, 2012 1:40:50 AM UTC-4, kp wrote: >>>>>>> >>>>>>> Hi all, >>>>>>> >>>>>>> This is the first time i am using Google charts. >>>>>>> Please find the attached html file in which i am able to select age >>>>>>> and roolNumber ranges using 2 NumberRangeFilter sliders. And the graphs >>>>>>> are >>>>>>> showing only the row values that fall within this range. >>>>>>> >>>>>>> Now i want to calculate the Average and geomean of Age >>>>>>> values which fall within the selected range and display them on the >>>>>>> webpage >>>>>>> instead of drawing the chart for all individual rows. >>>>>>> >>>>>>> Thanks in advance. >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "Google Visualization API" group. >>>>>> To view this discussion on the web visit https://groups.google.com/d/ >>>>>> **msg/google-visualization-api/-**/4u3twqDW1OUJ<https://groups.google.com/d/msg/google-visualization-api/-/4u3twqDW1OUJ> >>>>>> . >>>>>> To post to this group, send email to google-visualization-api@** >>>>>> googlegroups.com <[email protected]>. >>>>>> To unsubscribe from this group, send email to >>>>>> google-visualization-api+**[email protected]<google-visualization-api%[email protected]> >>>>>> . >>>>>> For more options, visit this group at http://groups.google.com/** >>>>>> group/google-visualization-**api?hl=en<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 view this discussion on the web visit >>>> https://groups.google.com/d/msg/google-visualization-api/-/VV0GGxf7BEsJ >>>> . >>>> >>>> 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. >>>> >>> >>> -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/oUQUkBwNPPEJ. 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.
