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/-/lN4X8yzwfm0J. 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.
