I'm trying to create a Pie Chart. The whole of the Pie Chart will be the
total number of surveys, TOTAL. I would then like to cut out the remaining
surveys, REMAINING. Both are in my query, but for the life of me I can not
figure out why the chart will not produce properly.


<cfquery name="remainingpercent" datasource="survey">
SELECT SUM(RemainingSurveys) AS Remaining, SUM(TotalSurveys) As Total
FROM Departments
</cfquery>


<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<cfoutput>
<cfchart
chartwidth="400"
chartheight="400">
<cfchartseries
type="pie"
query="remainingpercent"
valuecolumn="Total"
itemcolumn="Remaining">
</cfchart>