Inspiring

Question

Chart more than one query field.

Forum|Forum|13 years ago
November 28, 2012
1 reply
821 views

Hello I am creating a chart that will display two bar for each item colum. I can get one (the t3 bar) to display ok but I do not understand how to layout the second set of bars for the graph. Thank you

Here is what i got so far.

select Region,SUM(t1) as T1,SUM(t1unpaved) as T1Unpaved,
SUM(t2) as T2,SUM(t2unpaved) as T2Unpaved,
SUM(t3) as T3,SUM(t3unpaved) as T3Unpaved,
SUM(t4) as T4, SUM(t4Unpaved) as T4Unpaved,
SUM(t5) as T5, SUM(T5Unpaved) as T5Unpaved
from dbo.vp_MilesByTRC

group by Region

</cfquery>

<cfquery name="ps" dbtype="query">
select Region,SUM(t3) as T3,SUM(t1unpaved) as T3Unpaved FROM MASTER
where region ='PS'
group by region
</cfquery>

<cfquery name="ne" dbtype="query">
select Region,SUM(t3) as T3,SUM(t1unpaved) as T3Unpaved FROM MASTER
where region ='NE'
group by region
</cfquery>

<cfquery name="Sw" dbtype="query">
select Region,SUM(t3) as T3,SUM(t1unpaved) as T3Unpaved FROM MASTER
where region ='SW'
group by region
</cfquery>

<cfquery name="SE" dbtype="query">
select Region,SUM(t3) as T3,SUM(t1unpaved) as T3Unpaved FROM MASTER
where region ='SE'
group by region
</cfquery>

The chart displays one bar (t3)

How do I get the t3unpaved bar to display next to the t3 bar for each region. ?

</cfchart>

Database access

This topic has been closed for replies.

BKBK

Community Expert

You should get a chart with clusters of 5 bars. I wonder why you expect just 2 bars for each item.

To recreate your example, I went to the Adobe documentation and copied their examples. I added attributes borrowed from your example. I successfully got clusters of 4 bars, no sweat. My test code follows. You, too, can run it directly, as the datasource cfdocexamples comes with ColdFusion.

SELECT Departmt.Dept_Name,

Employee.FirstName,

Employee.LastName,

Employee.StartDate,

Employee.Salary,

Employee.Contract

FROM Departmt, Employee

WHERE Departmt.Dept_ID = Employee.Dept_ID

ORDER BY Employee.LastName, Employee.Firstname

</cfquery>

SELECT Dept_Name,

AVG(Salary) AS avgSal,

SUM(Salary) AS sumSal

FROM GetSalaryDetails

GROUP BY Dept_Name

</cfquery>

<cfchart

backgroundColor="white"

xAxisTitle="Department"

yAxisTitle="Salary Average"

font="Arial"

gridlines=6

showXGridlines="yes"

showYGridlines="yes"

showborder="yes"

seriesPlacement="cluster"

>

<cfchartseries

type="bar"

query="aggregates"

valueColumn="avgSal"

itemColumn="Dept_Name"

paintStyle="plain"

seriesLabel="Dept. Average Salaries"

seriescolor="993333" markerstyle="circle">

<cfchartseries

type="bar"

query="aggregates"

valueColumn="avgSal"

itemColumn="Dept_Name"

paintStyle="plain"

seriesLabel="Dept. Average Salaries"

seriescolor="FF0000" markerstyle="circle">

<cfchartseries

type="bar"

query="aggregates"

valueColumn="avgSal"

itemColumn="Dept_Name"

paintStyle="plain"

seriesLabel="Dept. Average Salaries"

seriescolor="517488" markerstyle="circle">

<cfchartseries

type="bar"

query="aggregates"

valueColumn="avgSal"

itemColumn="Dept_Name"

paintStyle="plain"

seriesLabel="Dept. Average Salaries"

seriescolor="FF9966" markerstyle="circle">

</cfchart>

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.