Do you want users to be able to download a CSV of the data, or do you want to be able to use one as a data source?
On Wednesday, July 18, 2012 12:42:44 PM UTC-4, Priyanka wrote: > > 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/-/wFwX2muCGTkJ. 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.
