Here is my delima.... I am developing dashboards for a company that refuses to use XML. I've been able to get the data from their CSV files into both DataGrids and the Spedo's. I am however unable to pull the data from DataGrid to create a pie chart.
Here is the contents of the CSV file (which is populated into the DataGrid). First row is the header.
ITEM,TOTAL HWH,12 STAT,14 LFSH,6 WI,7 PW,3
How do I go about getting this data into a chart? I assumed that since I had already spent the time getting the data into a datagrid that I could pull it out of the DataGrid and into the chart, but I have not been able to figure out how to do that.
Here is the code for my DataGrid also, if it matters:
<mx:DataGrid x="0" y="0" id="measures" width="301" height="200" maxHeight="200" maxWidth="628" minHeight="200" minWidth="628" color="#000000"> <mx:columns> <mx:DataGridColumn headerText="Measure" id="MSRE" dataField="col4"/> <mx:DataGridColumn headerText="Total" id="TTL" sortDescending="false" dataField="col5"/> </mx:columns> </mx:DataGrid>
The col4 and col5 get their data from the parser for CSV.
Thanks in advance for any help you can give me.