There's an example here: https://code.google.com/apis/ajax/playground/?type=visualization#pattern_formatter
and updated jsfiddle here: http://jsfiddle.net/asgallant/MqERY/5/ Note that I changed some of the HTML, as there was a weird effect where the positioning of the bar chart's div was overlapping the table, preventing interaction. On Thursday, July 19, 2012 1:35:13 PM UTC-4, Priyanka wrote: > > Hi Asgallant, > > Thankq for the solutions. I will try and let you know if i see any issues. > > Regd hyperlinks,in my case all the entries for a specific column will have > their corresponding hyperlinks. I have already tried using Pattern Format > but was unsuccessful in my attempt. Can you please give me some small > example on how this can be used? > > Thanks for your time! > > On Thursday, July 19, 2012 10:41:53 PM UTC+5:30, asgallant wrote: >> >> Added in links to the table via custom formatting with calculated >> columns: http://jsfiddle.net/asgallant/MqERY/4/ >> >> If all of the entries in a column will have links, it might be easier to >> use a pattern >> format<https://developers.google.com/chart/interactive/docs/reference#patternformatter> >> on >> the column and use a calculated column to return the formatted value to the >> table. >> >> On Thursday, July 19, 2012 7:58:39 AM UTC-4, Priyanka wrote: >>> >>> Also i want to have hyperlinks to column values in the table chart for >>> the same example. >>> For example when i click on Name 'Michael', it should take me to say >>> http://google.com >>> lly when i click on name 'Elisa', it should take me to say >>> http://facebook.com etc. >>> >>> i have used allowHtml for table options as shown below: >>> var table = new google.visualization.ChartWrapper({ >>> 'chartType': 'Table', >>> 'containerId': 'chart2', >>> 'options': { >>> 'width': '1200px', >>> 'allowHtml': true >>> }, >>> 'view' : { >>> 'columns': [0,1,3] >>> } >>> }); >>> >>> i am trying to use style (read in one of the docs) for values to var >>> data = google.visualization.arrayToDataTable to insert hyperlinks within >>> that but i was not successful. >>> Can you please help ? >>> >>> On Thursday, July 19, 2012 10:47:25 AM UTC+5:30, 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/-/kgT1K6jotokJ. 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.
