fluiter
Nov 24th 2005, 4:17 am
I'm realy desperate, so hopefully i can find the answer her.
I'm trying to get an integer number on the Yaxis of a chart.
What ever i've tried it always comes up with a tow decimal number instaed
of an integer number.
My code is as follows
<cfset aYearAgosDate = DateAdd('m',-11,now())>
<cfset end = now()>
<cfquery name="EMEA" datasource="issue">
SELECT count(region) as emeacount,
month(date_issue) AS month, year(date_issue) AS year
FROM tbl_issue
WHERE tbl_issue.date_issue
BETWEEN #aYearAgosDate# AND #end#
ANd region='EMEA'
GROUP BY year(date_issue),month(date_issue)
</cfquery>
<html>
<head>
<title>Global issues received.</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<cfchart showborder="yes" show3d="yes"
chartheight="400" chartwidth="600" yaxistitle="number" xaxistitle="Month " seriesplacement="stacked" databackgroundcolor="##FFFFCC" backgroundcolor="##FFFFCC">
<cfchartseries type="bar"
query="EMEA"
itemColumn="month"
valueColumn="emeacount"
seriesLabel="EMEA"/>
</cfchart>
<cfdump var="#EMEA#"/>
</body>
I'm trying to get an integer number on the Yaxis of a chart.
What ever i've tried it always comes up with a tow decimal number instaed
of an integer number.
My code is as follows
<cfset aYearAgosDate = DateAdd('m',-11,now())>
<cfset end = now()>
<cfquery name="EMEA" datasource="issue">
SELECT count(region) as emeacount,
month(date_issue) AS month, year(date_issue) AS year
FROM tbl_issue
WHERE tbl_issue.date_issue
BETWEEN #aYearAgosDate# AND #end#
ANd region='EMEA'
GROUP BY year(date_issue),month(date_issue)
</cfquery>
<html>
<head>
<title>Global issues received.</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<cfchart showborder="yes" show3d="yes"
chartheight="400" chartwidth="600" yaxistitle="number" xaxistitle="Month " seriesplacement="stacked" databackgroundcolor="##FFFFCC" backgroundcolor="##FFFFCC">
<cfchartseries type="bar"
query="EMEA"
itemColumn="month"
valueColumn="emeacount"
seriesLabel="EMEA"/>
</cfchart>
<cfdump var="#EMEA#"/>
</body>