Hi, unfortunately the NumberRangeFilter control<https://developers.google.com/chart/interactive/docs/gallery/controls#numberrangefilter> currently doesn't support dates, so the next closest thing is the ChartRangeFilter control<https://developers.google.com/chart/interactive/docs/gallery/controls#chartrangefilter>, but you still can't aggregate things automatically for a column (even for Pie charts). So I'm afraid that your only option is to use the ChartRangeFilter control and handle its events in such a way that it generates a new DataTable or DataView and redraws the chart.
- Sergey On Wed, Dec 19, 2012 at 2:15 PM, <[email protected]> wrote: > Hi all > > I'm a newbie and need help with creating a chart that I can filter the > data dynamiclly. > Assuming I have the following data table > *Date Type Amount* > 01/01/2012 blue 5 > 01/01/2012 green 6 > 01/01/2012 yellow 4 > 01/02/2012 blue 1 > 01/02/2012 green 3 > 01/02/2012 red 2 > 01/03/2012 blue 2 > 01/03/2012 red 5 > 01/03/2012 yellow 4 > > I want to create a chart (lets say ColumnChart) that displays sun(Amount) > group by Type and I want to filter it by the date with a dynamic controller. > for example: > If I select in the filter from 01/01/2012 to 01/01/2012 => I'll see 3 > columns, blue(5), green(6), yellow(4) > If I select in the filter from 01/01/2012 to 01/02/2012 => I'll > see 4 columns, blue(6), green(9), yellow(4), red(2) > > How can I do that?? > Many thanks, > Yoram > > > -- > 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/-/WgVCIDgg8FkJ. > 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 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.
