When trying to output a chart with the same itemcolumn
values, but different valuecolumn values cfchart only graphs the
second one. I would expect to get two slices of apples, one
equaling 10, the other 15, but I only get the 15. I'd even settle
for 25 apples!
apples - 10
apples - 15
oranges - 20
<cfscript>
level = queryNew('howmany,name');
queryAddRow(level);
querySetCell(level, 'howmany','10');
querySetCell(level, 'name','Apples');
queryAddRow(level);
querySetCell(level, 'howmany','15');
querySetCell(level, 'name','Apples');
queryAddRow(level);
querySetCell(level, 'howmany','20');
querySetCell(level, 'name','Oranges');
</cfscript>
<cfdump var="#level#">
<cfchart show3d="true" format="flash" chartwidth="800"
chartheight="550">
<cfchartseries type="pie"
query="level"
itemcolumn="name"
valuecolumn="howmany">
</cfchartseries>
</cfchart>
<cfchart show3d="true" format="flash" chartheight="500"
chartwidth="500">
<cfchartseries type="bar"
query="level"
itemcolumn="name"
valuecolumn="howmany">
</cfchartseries>
</cfchart>
how do you like them apples? I don't like them apples!