My MXML code is pasted below. Every example that I have found of a stacked column chart requires that each metric be returned as a seperate field in your data. What I need is to be able to have my horizontal axis be the month field (this is working), but I need the column subdivided by the site field using the count field. Is this possible within Flex?
~Brian
Code:
<?xml version="1.0" encoding="utf-8"?>
<mx:Application
xmlns:mx="[URL unfurl="true"]http://www.adobe.com/2006/mxml"[/URL]
layout="absolute"
horizontalAlign="left"
verticalGap="0"
width="100%" height="100%"
backgroundSize="100%"
backgroundColor="#ffffff"
paddingLeft="10"
paddingRight="10"
paddingBottom="10"
paddingTop="10">
<mx:ArrayCollection id="sData">
<mx:Array id="fltrSData">
<mx:Object month="2009-01" site="Site 1" count="22"/>
<mx:Object month="2009-01" site="Site 2" count="33"/>
<mx:Object month="2009-01" site="Site 3" count="44"/>
<mx:Object month="2009-02" site="Site 1" count="10"/>
<mx:Object month="2009-02" site="Site 2" count="20"/>
<mx:Object month="2009-02" site="Site 3" count="30"/>
<mx:Object month="2009-03" site="Site 1" count="35"/>
<mx:Object month="2009-03" site="Site 2" count="25"/>
<mx:Object month="2009-03" site="Site 3" count="15"/>
<mx:Object month="2009-04" site="Site 1" count="50"/>
<mx:Object month="2009-04" site="Site 2" count="20"/>
<mx:Object month="2009-04" site="Site 3" count="10"/>
</mx:Array>
</mx:ArrayCollection>
<mx:Panel width="100%" height="100%" layout="absolute" >
<mx:ColumnChart width="100%" height="100%" id="sChart" dataProvider="{sData}" type="stacked" showDataTips="true">
<mx:horizontalAxis>
<mx:CategoryAxis dataProvider="{sData}" categoryField="month"/>
</mx:horizontalAxis>
<mx:series>
<mx:ColumnSeries displayName="Count" yField="count"/>
</mx:series>
</mx:ColumnChart>
</mx:Panel>
</mx:Application>
~Brian