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