You would have to perform a filter as well as the cell hiding, but filtering out only rows where both 2010 and 2011 meet the criteria. The DataTable#getFilteredRows method won't do this for you, so you have to write custom filtering code, something like this: http://jsfiddle.net/asgallant/N9C5R/2/
On Thursday, March 21, 2013 4:24:26 AM UTC-4, Andreas wrote: > > Ok so it is not possible to both hide the correct data and filter out all > rows that are empty? For example hide the 2011 data for France if the > slider is set to 0-12 and then hide the entire France row once the sliderr > is set to 0-9? > > On Wednesday, March 20, 2013 8:57:53 PM UTC+1, asgallant wrote: >> >> Yes, that is correct. You can only filter out rows of data, so in that >> example, since France's 2011 data is in the range, the entire row gets >> filtered out. There is a way to do this a bit differently that hides the >> data instead of filtering: http://jsfiddle.net/asgallant/N9C5R/1/ >> >> On Wednesday, March 20, 2013 3:29:09 PM UTC-4, Andreas wrote: >>> >>> Thanks but the suggested solution does not solve the problem. If you >>> drag the slider so that it filters between 0 and 14 all organisations are >>> removed, even though some of them have data in the 0-14 range.For example >>> France has the value 10 for 2010 but is still filtered out. >>> >>> On Wednesday, March 20, 2013 8:15:48 PM UTC+1, asgallant wrote: >>>> >>>> The controls can only filter on one column per control. If you need to >>>> be able to filter on more than 1 column with a single control, you will >>>> need to hack around the limitation. Here's one way to do it: >>>> http://jsfiddle.net/asgallant/N9C5R/ >>>> >>>> On Wednesday, March 20, 2013 11:46:29 AM UTC-4, Andreas wrote: >>>>> >>>>> The following NumberRangeFilter works great: >>>>> >>>>> https://code.google.com/apis/ajax/playground/?type=visualization#numberrangefilter_control >>>>> >>>>> However, I am trying to filter on more then one column. Basically I >>>>> wish the filter to apply to both 2010 and 2011 year data. >>>>> This is what I am trying to do, but it does not work: >>>>> >>>>> var data = new google.visualization.DataTable(); >>>>> data.addColumn('string', 'Organisation'); >>>>> data.addColumn('number', '2010'); >>>>> data.addColumn('number', '2011'); >>>>> >>>>> data.addRows([ >>>>> ['France',10,15], >>>>> ['Germany',20,30], >>>>> ['Spain',30,5], >>>>> ['Italy',20,10], >>>>> ]); >>>>> >>>>> var slider = new google.visualization.ControlWrapper({ >>>>> 'controlType': 'NumberRangeFilter', >>>>> 'containerId': 'control1', >>>>> 'options': { >>>>> 'filterColumnLabel': '2010','2011', >>>>> 'minValue': 0, >>>>> 'maxValue': 60 >>>>> } >>>>> >>>> -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
