Flex Builder 3 Bubble Chart and Using Salesforce Data

[Mike_Green]

Hi,

I am struggling to add multiple series to a Flex Builder 3 Bubble Chart. I have no trouble adding multiple series with a simple bubble chart within flex itself but in the
example below when I connect to SFDC data the Chart appears once with one series of data then a second later with the second series of data.

Any suggestions greatly appreciated.








import mx.collections.ArrayCollection;
import com.salesforce.results.QueryResult;
import mx.utils.ObjectUtil;
import mx.controls.Alert;
import com.salesforce.AsyncResponder;
import com.salesforce.objects.LoginRequest;

private function login(event:Event):void {
var lr:LoginRequest = new LoginRequest();
//lr.server_url = parameters.server_url;
//lr.session_id = parameters.session_id;
lr.username = 'youraccount@sfdc.com.au';
lr.password = 'yourpassword';
lr.callback = new AsyncResponder(loadData, handleFault);
apex.login(lr);
}

[Bindable]
private var accountList:ArrayCollection = new ArrayCollection();
[Bindable]
private var accountList2:ArrayCollection = new ArrayCollection();

private function handleFault(faultbject):void {
Alert.show(ObjectUtil.toString(fault));
}

private function loadData(lrbject):void {
apex.query("Select CloseDate, Probability, Amount From Opportunity Where StageName='Prospecting'", new AsyncResponder(
function(qr:QueryResult):void {
if (qr.size > 0) {
accountList = qr.records;
}
bubblechart1.dataProvider = accountList;
},
handleFault)
);

apex.query("Select CloseDate, Probability, Amount From Opportunity Where StageName='Qualification'", new AsyncResponder(
function(qr:QueryResult):void {
if (qr.size > 0) {
accountList2 = qr.records;
}
bubblechart1.dataProvider = accountList2;
},
handleFault)
);
}




]]>




showDataTips="true"

>

dataProvider="{accountList}"
displayName="series1"
xField="CloseDate"
yField="Probability"
radiusField="Amount"
id="series1"
/>


dataProvider="{accountList2}"
displayName="series2"
xField="CloseDate"
yField="Probability"
radiusField="Amount"
id="series2"
/>

[Mike_Green]

Sorry Full code below first paste didn't copy all across








import mx.collections.ArrayCollection;
import com.salesforce.results.QueryResult;
import mx.utils.ObjectUtil;
import mx.controls.Alert;
import com.salesforce.AsyncResponder;
import com.salesforce.objects.LoginRequest;

private function login(event:Event):void {
var lr:LoginRequest = new LoginRequest();
//lr.server_url = parameters.server_url;
//lr.session_id = parameters.session_id;
lr.username = 'youraccount@sfdc.com.au';
lr.password = 'yourpassword';
lr.callback = new AsyncResponder(loadData, handleFault);
apex.login(lr);
}

[Bindable]
private var accountList:ArrayCollection = new ArrayCollection();
[Bindable]
private var accountList2:ArrayCollection = new ArrayCollection();

private function handleFault(faultbject):void {
Alert.show(ObjectUtil.toString(fault));
}

private function loadData(lrbject):void {
apex.query("Select CloseDate, Probability, Amount From Opportunity Where StageName='Prospecting'", new AsyncResponder(
function(qr:QueryResult):void {
if (qr.size > 0) {
accountList = qr.records;
}
bubblechart1.dataProvider = accountList;
},
handleFault)
);

apex.query("Select CloseDate, Probability, Amount From Opportunity Where StageName='Qualification'", new AsyncResponder(
function(qr:QueryResult):void {
if (qr.size > 0) {
accountList2 = qr.records;
}
bubblechart1.dataProvider = accountList2;
},
handleFault)
);
}




]]>




showDataTips="true"

>

dataProvider="{accountList}"
displayName="series1"
xField="CloseDate"
yField="Probability"
radiusField="Amount"
id="series1"
/>


dataProvider="{accountList2}"
displayName="series2"
xField="CloseDate"
yField="Probability"
radiusField="Amount"
id="series2"
/>

[Mike_Green]

Sorry, Still does not paste all Code into Window,
I have added it as an attachment.