I have an existing arrayCollection coming in that looks like: id,mydate,type,... 1,1/1/2008,type1 2,1/2/2008,type2 3,1/7/2008,type3 4,1/7/2008,type1 5,1/8/2008,type2 ...
This is a dataProvider for a dataGrid. What I'd like to do is create a new dataProvider for a chart, based on this existing data. I need to count the number of each type for each week resulting in a new ArrayCollection weekending, type, count 1/7/2008,type1,10 1/7/2008,type2,5 My chart would display Yaxis Number(OfEachType) Xaxis WeekEndingDate I'd like 3 series (type1,type2,type3) so I can fill colors for each type. I'd prefer not the have to query the database again to produce an ArrayCollection dataProvider for the chart. There are some complicated SQL options for this, but I was wondering if Flex offered an easier way for me to do this so I only make one trip to the database. I know how to loop through an arraycollection and how to produce a new dataProvider, but I don't know how to handle converting/grouping the dates by weekending date in the new ArrayCollection. Any assistance would be appreciated. Thanks, Don