Re: format y-axis in cfchart

2005-03-16 Thread cf coder 
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

 
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


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  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

format y-axis in cfchart

2005-03-15 Thread cf coder 
The values displayed on the y-axis are are mix of float and int. The chart 
displays int values on the y-axis if I use only one cfchartseries tag. The code 
below calculates the value for the gridlines and scaleto attributes.

[code]



[/code]
When I output this variable, the value returned is 88 and when I execute the 
below code I get the following on the y-axis:

6 ,18, 30, 42, 54, 66, 78

[code]




 

   




[/code]

However, when I add 3 more chartseries tag to the above code, I get
27.7, 83, 138.4, 193.8, 249.1, 304.5

[code]






 

   



 

   



 
  
   



 
  
   




[/code]

Can any mathematician help please

Regards
cfcoder

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198820
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54