Thankyou Asgallant. On Tuesday, July 31, 2012 2:45:07 AM UTC+5:30, asgallant wrote: > > You can use this to get the selected values: > > var sel = categoryPicker.getState().selectedValues; > > On Monday, July 30, 2012 8:49:31 AM UTC-4, Priyanka wrote: >> >> 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/-/7VjYlX25RA4J. 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.
