Coldfusion cfchart stacked order?

The simplest way would be to use a QofQ: select clusterPrivateReferrals. MsgCount as privateReferrals, clusterNHSReferrals. MsgCount as NHSReferrals, clusterPrivateReferrals.

OrganizationName from clusterPrivateReferrals join clusterNHSReferrals on clusterNHSReferrals. OrganizationName = clusterPrivateReferrals. OrganizationName order by (privateReferrals+privateReferrals) desc I've not tested this, so you may need to tweak it a little.

Now, you should be able to use the two Referrals columns as the data columns for the graph.

I wasn't aware you could do that sort of thing in a QoQ but now that I see it, I don't see why it wouldn't work. For some reason I had it in my head that you could do a QoQ with a single originating query. – Jason Oct 4 '10 at 18:50 I've used QofQ to join data from across datasources before.It's handier than people tend to give it credit for.

– Ben Doom Oct 4 '10 at 18:56 That nearly does it Ben, and got me onto the right track. See above for working code. – Saul Oct 4 '10 at 22:55.

Something like this (can not test, so it may need some fixes): SELECT organisationName, messageID, listSize, count(messageID)*1000/listSize as totalMsgCount FROM clusterReferrals WHERE datecreated>#refRateStartDate# GROUP BY organisationName, listSize After that update your existing queries to include select from clusterCombinedReferrals and order by totalMsgCount at first place, also drop the filtering by date as it already applied.

I don't think you can without first outputting the queries to a structure and then sorting it and outputting the data from that with the cfchartdata tag inside each cfchartseries. Something like this, maybe. I did this locally and it worked, but then I tried to convert the code to work with your queries and column names, so it might not work off a straight copy and paste.(But it might!) It also assumes that the length of the two queries will always be the same.

If that isn't true, you might need to code around that.

Yes, putting into arrays would work, but Ben's QOQ solution above is slicker – Saul Oct 4 '10 at 22:55.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.