cfchartseries

<cfchartseries 
alpha = &quot;Integer between 0 and 1&quot; 
animate = &quot;JSON string representation&quot; 
aspect = &quot;text&quot; 
background = &quot;JSON string representation&quot; 
bevel = &quot;JSON string representation&quot; 
border = &quot;JSON string representation&quot; 
color = &quot;text&quot; 
data = &quot;JSON string representation&quot; 
dataFormat=&quot;Numbering format of the data series&quot;
hovermarker = &quot;JSON string representation&quot; 
marker = &quot;JSON string representation&quot; 
type=&quot;type&quot; 
itemColumn =&quot;query column&quot; 
label = &quot;text&quot; 
valueColumn=&quot;query column&quot; 
colorlist = &quot;list&quot; 
dataLabelStyle=&quot;style&quot; 
markerStyle=&quot;style&quot; 
paintStyle=&quot;plain|raise|shade|light&quot; 
query=&quot;query name&quot; 
scales = &quot;comma-seperated list of axes&quot; 
shadow = &quot;JSON string representation&quot; 
seriesColor=&quot;hexadecimal value|web color&quot; 
seriesLabel=&quot;label text&quot;> 
toolTip = &quot;JSON string representation&quot; 
zColumn = &quot;query column&quot; 
type=&quot;type&quot; 
itemColumn=&quot;query column&quot; 
valueColumn=&quot;query column&quot; 
colorlist = &quot;list&quot; 
dataLabelStyle=&quot;style&quot; 
markerStyle=&quot;style&quot; 
paintStyle=&quot;plain|raise|shade|light&quot; 
query=&quot;query name&quot; 
rules=&quot;rules for the charts&quot;
seriesColor=&quot;hexadecimal value|web color&quot; 
seriesLabel=&quot;label text&quot;> 
</cfchartseries>

<!--- 次の例では、cfdocexamples データベース内の給与データを分析し、
部署別の平均給与を示す棒グラフを生成します。---> 

<!--- データベースから生データを取得します。---> 
<cfquery name=&quot;GetSalaries&quot; datasource=&quot;cfdocexamples&quot;> 
SELECT Departmt.Dept_Name, 
Employee.Dept_ID, 
Employee.Salary 
FROM Departmt, Employee 
WHERE Departmt.Dept_ID = Employee.Dept_ID 
</cfquery> 

<!--- クエリオブクエリを使用して、各部署の統計データを含む ---> 
<!--- 新しいクエリを生成します。---> 
<!--- AVG と SUM は統計値を計算します。 ---> 
<!--- GROUP BYは、各部署の結果を生成します。---> 
<cfquery dbtype = &quot;query&quot; name = &quot;DataTable&quot;> 
SELECT 
Dept_Name, 
AVG(Salary) AS avgSal, 
SUM(Salary) AS sumSal 
FROM GetSalaries 
GROUP BY Dept_Name 
</cfquery> 

<!--- 生成された数値を千単位で表示するように再書式設定します。 ---> 
<cfloop index = &quot;i&quot; from = &quot;1&quot; to = &quot;#DataTable.RecordCount#&quot;> 
<cfset DataTable.sumSal[i] = Round(DataTable.sumSal[i]/1000)*1000> 
<cfset DataTable.avgSal[i] = Round(DataTable.avgSal[i]/1000)*1000> 
</cfloop> 

<h1>Employee Salary Analysis</h1> 
<!--- 棒グラフ、クエリオブクエリから ---> 
<cfchart format=&quot;flash&quot; 
xaxistitle=&quot;Department&quot; 
yaxistitle=&quot;Salary Average&quot;> 

<cfchartseries type=&quot;bar&quot; 
query=&quot;DataTable&quot; 
itemcolumn=&quot;Dept_Name&quot; 
valuecolumn=&quot;avgSal&quot; /> 
</cfchart>

<cfchart format =&quot;html&quot; type=&quot;pie&quot;> 
<cfchartseries> 
<cfchartdata item=&quot;New car sales&quot; value=&quot;50000&quot;> 
<cfchartdata item=&quot;Used car sales&quot; value=&quot;25000&quot;> 
<cfchartdata item=&quot;Leasing&quot; value=&quot;30000&quot;> 
<cfchartdata item=&quot;Service&quot; value=&quot;40000&quot;> 
</cfchartseries> 
</cfchart>

<cfchart format =&quot;html&quot; type=&quot;bubble&quot; query=&quot;ChartQuery&quot; showlegend=&quot;false&quot;> 
<cfchartseries query=&quot;ProdQuery&quot; type=&quot;bubble&quot; itemcolumn=&quot;title&quot; valuecolumn=&quot;total_days&quot; zcolumn=&quot;rem_days&quot; label=&quot;Total_Days&quot;> 
</cfchart>

<cfchart format =&quot;html&quot; type=&quot;bubble&quot; que ry = &quot; ChartQ ue ry &quot; showlegend=&quot;false&quot; labels=#[{&quot;text&quot;=&quot;Hello Label&quot;,&quot;hook&quot;:&quot;node:plot=0,index=2,offset-x=-10,offset-y=-90&quot;}]#> 
<cfchartseries type=&quot;bubble&quot; label=&quot;Total_Days&quot;> 
<cfchartdata item=1 value=10 zvalue=40> 
<cfchartdata item=2 value=20 zvalue=30> 
<cfchartdata item=3 value=30 zvalue=20> 
<cfchartdata item=4 value=20 zvalue=35> 
<cfchartdata item=5 value=40 zvalue=10> 
</cfchartseries> 
</cfchart>