Hi again, I'm just so loosing my focus here. Not knowing how this things works
is probably what's getting me all frustrated. Ok, here is what my query looks
like
<cfquery name="qBar" datasource="testDB">
SELECT CONVERT(varchar(15), dt.dtlogged, 106) AS dtlogged, dt.jobcount,
j.jobPriority, j.jobNumber
FROM (
SELECT CAST(CONVERT(varchar(15), logdatetime, 106) AS datetime) AS dtlogged,
COUNT(*) AS jobcount
FROM job
WHERE logdatetime >= '01/02/2005 00:00:00'
AND logdatetime <= '02/02/2005 23:59:59'
GROUP BY CAST(CONVERT(varchar(15), logdatetime, 106) AS datetime)
) dt JOIN job j ON dt.dtlogged = CAST(CONVERT(varchar(15), j.logdatetime,
106) AS datetime)
ORDER BY dtLogged
</cfquery>
And when I dump it, it looks something like this:
query
CALLCOUNT JOBNUMBER JOBPRIORITY DTLOGGED
1 2 01BS093789 2 01 Feb 2005
2 2 01BS093795 3 01 Feb 2005
3 3 01BS093872 6 02 Feb 2005
4 3 01BS093883 6 02 Feb 2005
5 3 01BS093888 1 02 Feb 2005
I hope it is making sense so far.
I now what to build a chart with the date on the x-axis and the no of jobs
logged in a day on the y-axis. In the example above, there are 2 jobs logged on
the 1st of Feb each with a different jobPriority. I want the the user to be
able to see this in the chart which is why I've added the <cfif> block inside
the chartseries tag, but becuase the cfif is inside the chartseries tag and not
outside, the chart representation of the data is not right. I don't know the
right way to do this. Can you please help
Regards
cfcoder
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198927
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
