LiveDocs Comments - coldfusion - 6.1 - htmldocs - tags-a12.htm

coldfusion/6.1/htmldocs/tags-a12.htm

2004-10-29T04:24:01

What happens with some values?

renerates an error "The value of the attribute VALUE is invalid". If the value is "14,11" - then it works!
CF MX 6.1

coldfusion/6.1/htmldocs/tags-a12.htm

zedfox — 2004-08-06T21:02:04

Here is an example of using a combination of and tags. I didn't think of this and now that I have got a nice graph working, let me share with you how things worked for me. Hopefully someone will be benefited. I have also used pre-set (cfset) variables in the following code:

My intention: Two lines use cfchartdata looping through a query. One line uses the query directly using cfchartseries. This code has been picked up from a trial script. I am not able to get to the original script right now but this is where I got things started to work. Hope it helps.

#title#

chartheight="300"
chartwidth="450"
showxgridlines="no"
showygridlines="yes"
gridlines="10"
xaxistitle="Date"
yaxistitle="#yaxistitle#"
markersize="1"
>

type="line"
seriesColor="green"
paintStyle="shade"
markerStyle="circle"
serieslabel="#serieslabel1#"
>

type="line"
seriesColor="blue"
paintStyle="shade"
markerStyle="circle"
serieslabel="#serieslabel2#"
>

type="line"
seriesColor="blue"
paintStyle="shade"
markerStyle="circle"
query="normals"
itemcolumn="mydate"
serieslabel="#serieslabel2#"
valuecolumn="#valuecolumn#"
>

coldfusion/6.1/htmldocs/tags-a12.htm

Sarge — 2004-03-19T13:53:32

We are working to improve the examples in the ColdFusion reference pages. We propose to replace the current example on this page with the the following example. If you have any comments on this example, add them to this page.

The following example analyzes the salary data in the CompanyInfo database and generates a bar chart showing average salary by department. The body of the cfchartseries tag loops over a cfchartdata tag to include data available from the query.

SELECT Departmt.Dept_Name,
Employee.Dept_ID,
Employee.Salary
FROM Departmt, Employee
WHERE Departmt.Dept_ID = Employee.Dept_ID

SELECT
Dept_Name,
AVG(Salary) AS avgSal,
SUM(Salary) AS sumSal
FROM GetSalaries
GROUP BY Dept_Name

Employee Salary Analysis

xaxistitle="Department"
yaxistitle="Salary Average">

itemcolumn="Dept_Name"
valuecolumn="avgSal">