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.
