cfchart stacked series, multiple values

[ndeeley]

Hi,

I'm trying to create a stacked series chart using cfchart where the stack has multiple values.

For example, my columns could be feedback codes, with the values being a stack of the count of the type of action taken.

I can generate the columns, but can't find a way to split the stack into the count of the action taken type.

Any ideas on how I do this? I previously abandoned cfchart for google charts but have gone back to them as we are now on CF10 (from 5!)

Data:

Equip No Work Group code1 Feedback Cause code3 Action Taken code4 Follow Up
10283948 WWT04 IOOH Issue Out of Hours
10283948 ENGA06 MECH Mechanical REPR Repair
10283948 WWT04 IOOH Issue Out of Hours
10283948 WWT04 IOOH Issue Out of Hours
10283948 WWT04 IOOH Issue Out of Hours
10283948 ENGA06 BLOC Blockage ENGINEERING USE ONLY INVS Investigate
10283948 WWT04 IOOH Issue Out of Hours
10283948 ENGA06 MECH Mechanical REPL Replace
10283948 WWT04 IOOH Issue Out of Hours
10283948 WWT04 IOOH Issue Out of Hours
10283948 WWT04 IOOH Issue Out of Hours
10283948 ENGA06 MECH Mechanical INVS Investigate


Query:

<cfquery datasource="cfTSP1_Dev" name="WOFeedbackChart">
select			count(WO_Job_Codex1) as Code1,
				WO_FB_Cause,
				count(WO_Job_Codex4) as Code4,
				WO_FB_Action_Taken
			
FROM			StoresII.ClosedWO
WHERE			Equip_No = '000010283948' and (WO_Job_Codex1 is not null) and (WO_Job_Codex1 <> '')
group by		WO_FB_Cause, WO_FB_Action_Taken
	
</cfquery>

cheers
Neil