Answered
CFChart Stacked
I've read most of the CFChart posts but cannot get this to
work exactly how I want it to.
What I need is for the chart to display TQ along the X axis and Counts along the Y axis. Then I need two values displayed as stacked bars for each TQ along the X axis. The first value is the InsideTQ, the next value is OutsideTQ. Both InsideTQ and OutsideTQ equal the total count of points for a TQ value.
e.g TQ value 5 has a count of 60 InsideTQ points and 55 OutsideTQ points, so TQ value 5 has a total of 115 points.
This part works pretty good. The problem is that I have muliple Originators for each TQ and for each InsideTQ and OutsideTQ. I want to display the TQ values along the X axis ( 1 to 15 ) but only display them once. In each TQ value I want to have the Originators with their In and Out values displayed as stacked bars.
e.g. Originator Y, TQ 5, Inside 60, Outside 55 next show Originator Z, TQ 5, Inside 40, Outside 35.
If it isn't asking too much, I would also always like for the InsideTQ to display green and the OutsideTQ to display red. When I try to force the colors I end up with the entire stacked bar the same color.
What I usually end up with is the TQ going from 1 to 15 for the first Originator and then starting over at 1 for the next Originator.
Here's my query and my chart. Thanks in advance for your help...
BTW -- I'm using a <CFLOOP> then a <CFOUTPUT> instead of a <CFOUTPUT> with a GROUP because this code sits within a report which is already enclosed in <CFOUTPUT> tags.
What I need is for the chart to display TQ along the X axis and Counts along the Y axis. Then I need two values displayed as stacked bars for each TQ along the X axis. The first value is the InsideTQ, the next value is OutsideTQ. Both InsideTQ and OutsideTQ equal the total count of points for a TQ value.
e.g TQ value 5 has a count of 60 InsideTQ points and 55 OutsideTQ points, so TQ value 5 has a total of 115 points.
This part works pretty good. The problem is that I have muliple Originators for each TQ and for each InsideTQ and OutsideTQ. I want to display the TQ values along the X axis ( 1 to 15 ) but only display them once. In each TQ value I want to have the Originators with their In and Out values displayed as stacked bars.
e.g. Originator Y, TQ 5, Inside 60, Outside 55 next show Originator Z, TQ 5, Inside 40, Outside 35.
If it isn't asking too much, I would also always like for the InsideTQ to display green and the OutsideTQ to display red. When I try to force the colors I end up with the entire stacked bar the same color.
What I usually end up with is the TQ going from 1 to 15 for the first Originator and then starting over at 1 for the next Originator.
Here's my query and my chart. Thanks in advance for your help...
BTW -- I'm using a <CFLOOP> then a <CFOUTPUT> instead of a <CFOUTPUT> with a GROUP because this code sits within a report which is already enclosed in <CFOUTPUT> tags.
AdChoices