469,366 Members | 2,342 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,366 developers. It's quick & easy.

cfchart stacked series, multiple values

139 100+
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:
Expand|Select|Wrap|Line Numbers
  1. <cfquery datasource="cfTSP1_Dev" name="WOFeedbackChart">
  2. select            count(WO_Job_Codex1) as Code1,
  3.                 WO_FB_Cause,
  4.                 count(WO_Job_Codex4) as Code4,
  5.                 WO_FB_Action_Taken
  6.  
  7. FROM            StoresII.ClosedWO
  8. WHERE            Equip_No = '000010283948' and (WO_Job_Codex1 is not null) and (WO_Job_Codex1 <> '')
  9. group by        WO_FB_Cause, WO_FB_Action_Taken
  10.  
  11. </cfquery>
  12.  
cheers
Neil
Jun 2 '14 #1
0 5807

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Henri Schomaecker | last post: by
5 posts views Thread by Homer Simpson | last post: by
16 posts views Thread by Nikolay Petrov | last post: by
8 posts views Thread by Chris A via AccessMonster.com | last post: by
reply views Thread by g.o.atkins | last post: by
2 posts views Thread by satyanarayan sahoo | last post: by
reply views Thread by Maric Michaud | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.