Hi, Thank you for your input. I know about the grouping capabilities of the DataTable. My question is, would the result of this grouping still be considered as a continuous?
Here is the problem: my current data is already aggregated by week with an integer representing the year and the week (yyyyww). The problem happens when I jump from 201252 to 201301: since I need this to be a continuous variable in order to use a ChartRangeFilter, a huge gap is generated between these two numbers. That's why I need the underlying data to be of type Date and the grouping done on the chart, as the example I posted about Microsoft's chart... Any thoughts? Cheers, Bernardo. Sexta-feira, 22 de Fevereiro de 2013 16:06:00 UTC, asgallant escreveu: > > Yes, you can group data, using the > google.visualization.data.group<https://developers.google.com/chart/interactive/docs/reference#google_visualization_data_group>method. > This takes a DataTable and performs a group on it to create a new > DataTable, which you can then use to draw your chart. > > On Friday, February 22, 2013 6:01:38 AM UTC-5, Bernardo Alves wrote: >> >> Hi, >> >> I have a chart with continuous data (date type) along the h-axis. What I >> would like to do is group the underlying variable, let's say "Sales", with >> a function (SUM, for example) by a specific aggregation of dates, such as >> Week, Month or Quarter. >> >> I am able to do this with Microsoft's Datavisualization.Charting charts >> for .net. Here is a line of code to do this: >> >> *Chart1.DataManipulator.Group("SUM, X:CENTER", 1, IntervalType.Weeks, 1, >> DateTimeIntervalType.Days, ChSeries)* >> >> Could I do something similar with Google Charts? >> >> Thanks for any insights you could share on the subject. >> >> Cheers, >> Bernardo >> > -- 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.
