You can make Date objects out of that, which will fix your continuous data problem. Create Date objects in the form:
new Date(year, 0, week * 7) You can then format your data to display year and week of year. When you group on the date axis, you can group by months or quarters, however you like, and format the display as appropriate. On Friday, February 22, 2013 11:29:32 AM UTC-5, Bernardo Alves wrote: > > 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.
