I want the users to be able to download a CSV of the table with filtered data that we currently on the webpage.
On Wednesday, July 18, 2012 11:46:55 PM UTC+5:30, asgallant wrote: > > 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/-/l1Qz2KVX6wsJ. 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.
