MACROMEDIA COLDFUSION MX 61-DEVELOPING COLDFUSION MX, Develop Manual

Page: 624 / 860

624 Chapter 28: Charting and Graphing Data
You can also rewrite this example to use the
cfoutput
and
cfchartdata
tags within the
cfchartseries
tag, instead of using the loop, to round the salary data, as the following code
shows:
<cfchartseries
type="bar"
seriesColor="olive"
paintStyle="plain">
<cfoutput query="deptSalaries">
<cfchartdata item="#dept_name#" value=#Round(AvgByDept/1000)*1000#>
</cfoutput>
</cfchartseries>
Charting individual data points
When you chart individual data points, you specify each data point by inserting a
cfchartdata
tag in the
cfchartseries
tag body. For example, the following code creates a simple pie chart:
<cfchart>
<cfchartseries type="pie">
<cfchartdata item="New Vehicle Sales" value=500000>
<cfchartdata item="Used Vehicle Sales" value=250000>
<cfchartdata item="Leasing" value=300000>
<cfchartdata item="Service" value=400000>
</cfchartseries>
</cfchart>
This pie chart displays four types of revenue for a car dealership. Each
cfchartdata
tag specifies
a department’s income and description for the legend.
Note: If two data points have the same item name, ColdFusion graphs the value for the last one
specified within the cfchart tag.
<cfloop index="i" from="1"
to="#DeptSalaries.RecordCount#">
<cfset DeptSalaries.AvgByDept[i]=
Round(DeptSalaries.AvgByDept[i]
/1000)*1000>
</cfloop>
Loop through all the rows in DeptSalaries query and
round the salary data to the nearest thousand. This
loop uses the query variable RecordCount to get the
number of rows and changes the contents of the
query object directly.
<cfchart
xAxisTitle="Department"
yAxisTitle="Salary Average"
font="Arial"
gridlines=6
showXGridlines="yes"
showYGridlines="yes"
showborder="yes"
show3d="yes" >
<cfchartseries
type="bar"
query="DeptSalaries"
valueColumn="AvgByDept"
itemColumn="Dept_Name"
seriesColor="olive"
paintStyle="plain"/>
</cfchart>
Create a bar chart using the data from the
AvgByDept column of the DeptSalaries query.
Label the bars with the Department names.
Code Description