The behavior of the DateRangeFilter is consistent with the behavior of the NumberRangeFilter, which also drops null values. I'm not sure there is a good way to get the effect that you want. Lets say you are filtering on your closing date, and you move the low end thumb of the slider. Should the filter ignore nulls or not? What if you move the high end?
Maybe there should be a way for users to select an unfiltered state, but I'm not sure how that would work. On Friday, November 29, 2013 6:08:29 AM UTC-5, Romain Vialard wrote: > > A DateRangeFilter is available since the 11/26 update. It's useful but > there's an issue: > > If you create a dashboard from data in a spreadsheet and use a > DateRangeFilter, all rows which don't have a date (blank cell) will be > skipped. > Not having the appropriate value for all entries happens a lot (eg: > "Closing date" - you have a date for all closed requests but blank cell for > open requests). > > It would be better to display all entries and hide the entries with no > date only when you start playing with the DateRangeFilter (but display the > entries if you are using other filters but not the DateRange one). Similar > to how the CategoryFilter works. > > Example: > http://jsfiddle.net/9qUnE/2/ > Spreadsheet: > https://docs.google.com/spreadsheet/ccc?key=0AnxR7WfXrj7adGEwamJMSXRuTzBBUm1OVkZ1cDh3ZHc&usp=sharing > > If have opened a feature request in the issue tracker: > > https://code.google.com/p/google-visualization-api-issues/issues/detail?id=1387 > -- 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. For more options, visit https://groups.google.com/groups/opt_out.
