Question
cfchart help needed
Yes I searched through the history on this and found where
people had attempted to answer.... but I still don't get it.
I want a graph that has distance numbers going up the y-axis and dates going across - verticaly (perferably in a mmm-d format)
My Query:
<cfquery name="totalMonth" datasource="2onboard">
SELECT sum(distance) AS curMonthDistance, sum(time) AS curMonthTime
FROM bockWalk
WHERE Month(walkDate) = #Month(Now())# AND Year(walkDate) = #Year(Now())#
</cfquery>
My existing cfchart code:
<cfchart format="jpg"
chartwidth="575"
chartheight="150"
yaxistitle="Miles"
showygridlines="yes"
labelformat="number"
showborder="yes">
<cfchartseries type="bar"
query="monthlyChart"
valuecolumn="distance"
itemcolumn="walkDate"
seriescolor="ff0000">
</cfchartseries>
</cfchart>
Currently I get what I want except the date format is shown as yyyy-mm-dd 00:00:00 and is horizontal.
I would also like for this to be in flash, but if I put "flash" in the format line, nothing shwos up.
Extended thought - I would like to include a second field of information (time - number field) as part of the rollover feature.
stumped
I want a graph that has distance numbers going up the y-axis and dates going across - verticaly (perferably in a mmm-d format)
My Query:
<cfquery name="totalMonth" datasource="2onboard">
SELECT sum(distance) AS curMonthDistance, sum(time) AS curMonthTime
FROM bockWalk
WHERE Month(walkDate) = #Month(Now())# AND Year(walkDate) = #Year(Now())#
</cfquery>
My existing cfchart code:
<cfchart format="jpg"
chartwidth="575"
chartheight="150"
yaxistitle="Miles"
showygridlines="yes"
labelformat="number"
showborder="yes">
<cfchartseries type="bar"
query="monthlyChart"
valuecolumn="distance"
itemcolumn="walkDate"
seriescolor="ff0000">
</cfchartseries>
</cfchart>
Currently I get what I want except the date format is shown as yyyy-mm-dd 00:00:00 and is horizontal.
I would also like for this to be in flash, but if I put "flash" in the format line, nothing shwos up.
Extended thought - I would like to include a second field of information (time - number field) as part of the rollover feature.
stumped
AdChoices