I am having a problem with CFCHART. My code attached seems to be produce
nothing but a blank flash object. Even if I add an xAxisTitle or yAxisTitle I
still have a blank canvas. I have seen the data in cfdump and it is correct, so
I am stumped. Can anyone see something I am overlooking?
<cfquery name="chartData" dataSource="xxxxxt">
SELECT count(ID) as dptCount,
date(Time) AS startYear
FROM log_files
WHERE CustomerID = #Session.CustomerID#
GROUP BY date(Time)
</cfquery>
<cfchart>
<cfchartseries type="bar"
query="chartData"
itemColumn="date(Time)"
valueColumn="dptCount"
seriesLabel="Output Data"/>
</cfchart>
-==cfSearching==- - 29 Feb 2008 07:56 GMT
> itemColumn="date(Time)"
That is not column in your query. You aliased it AS startYear. Use the alias.