I am looking through the graphing components that come with Flex and they seem straightforward. However, all of the examples use arrays as the data provider where calculations have already been performed. Data is rarely stored in the database that way, so I am wondering how users here obtain those types of values to put into their graphs.
The database I am using to store this data (Quickbase) is only capable of serving up the XML in a flat structure. How would I perform calculations on this data? Should I create an new array by looping through the existing array collection? In Ruby, I've used hashes before, with the index being the value on which you group. I didn't think this was efficient though. As an example, I am trying to create a running total graph of number of employee hires by month. Thanks for your help!