Hi Asgallant, Thankyou for the solution. This works!
Couple of other questions that i have here are: How do i get the value of what has been selected using category filter. i can see that there is an option to set a default value but i need to reverse. What i need here is i need to have a dropdown (category filter) below the barchart which will have the option for GeoMean and avaerage. Based on the value selected, if geomean is selected the barchart should draw/display the values for geomean. elseif average is selected, the barchart should display the values for averages. Is this possible in google charts? Thank you !! On Thursday, July 19, 2012 11:25:08 PM UTC+5:30, asgallant wrote: > > 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/-/P-6tenvJougJ. 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.
