Ok, I wrote a hack to download the data in CSV format without invoking a call to a server: http://jsfiddle.net/asgallant/MqERY/3/
It's not perfect, as there is no way to specify the name of a file in a URI string (hence the popup when you click the button), but it is functional. On Thursday, July 19, 2012 1:17:25 AM UTC-4, Priyanka wrote: > > 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/-/AijdRdre0jEJ. 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.
