Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Line chart for number of calls per 30mins interval Post Reply Post New Topic
<< Prev Page  of 3
Author Message
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 11 Aug 2009 at 6:40am
This is a no self degradation web site  Wink
But I am glad you got it working.
 
If you really want / need this to be every half hour you will need to alter your times fall on each 1/2 hour then alter your group to "for each second".
 
i think this formula should work for that a way to do that but create it and drop it on your cnavas to make sure it converts all your times to the correct 1/2 hour increment
 
TIME(HOUR(TIME({Qlog1.Call In Time})),if(minute(TIME({Qlog1.Call In Time})))>=30 then 30 else 00,00)
IP IP Logged
guan
Newbie
Newbie


Joined: 06 Aug 2009
Online Status: Offline
Posts: 17
Quote guan Replybullet Posted: 11 Aug 2009 at 4:57pm
hi thanks again

sorry do i put this formula under group expert?
TIME(HOUR(TIME({Qlog1.Call In Time})),if(minute(TIME({Qlog1.Call In Time})))>=30 then 30 else 00,00)

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 11 Aug 2009 at 5:38pm
Update your "TimeGroup" formula with it.
In stead of just comverting the Qlog1.Call In Time field from text to a time field it will also change it to the half hour time...for example
9:17 am will become 9:00:00 am
10:34 am becomes 10:30:00 am
10:29 am becomes 10:00:00 am
etc.
Now all your data falls into 1/2 hour fields to the second.
By doing that you can change your chart from grouping every hour to grouping for ecery second. Since this field converts to only displaying every 1/2 on the second you can get counts per 1/2 hour.
Make sense?
IP IP Logged
guan
Newbie
Newbie


Joined: 06 Aug 2009
Online Status: Offline
Posts: 17
Quote guan Replybullet Posted: 11 Aug 2009 at 7:17pm
woohoo! it worked! ahah
thanks again! crystal report is getting more fun.
im going to try to learn ms report from ms sql 2008 too
IP IP Logged
guan
Newbie
Newbie


Joined: 06 Aug 2009
Online Status: Offline
Posts: 17
Quote guan Replybullet Posted: 12 Aug 2009 at 1:51am
today i tried doing monthly instead of daily
it worked
however there was some slight error
it manage to generate a report chart for july

however for august it had some trouble.

for august i had entered around 1 week worth of data. there was some grouping issues, the dates for august became i.e. 8/4/09, 8/5/09, 8/6/09 hence it generated 3 line chart for 3 months.

i checked at group expert, DAte Group, then i clicked browse data. all the dates for august was 8/4/09, 8/5/09, 8/6/09 instead of 4/8/09, 5/8/09, 6/8/09. july however was alright.

any ideas? i have already checked the format settings and everything was okay. dammmittttt
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 12 Aug 2009 at 7:54am
Your date({Qlog1.Call Date}) formula is inverting Month and Day fields.
Change it to this mess...(copy and paste it)
 
date(
tonumber(right({Qlog1.Call Date}
,4))
,
tonumber(mid({Qlog1.Call Date}
,instr({Qlog1.Call Date},"/")+1,
(if mid({Qlog1.Call Date}
,instr({Qlog1.Call Date},"/")+3,1)="/" then 2 else 1)
))
,
tonumber(left({Qlog1.Call Date}
,instr({Qlog1.Call Date},"/")-1))
)
IP IP Logged
guan
Newbie
Newbie


Joined: 06 Aug 2009
Online Status: Offline
Posts: 17
Quote guan Replybullet Posted: 12 Aug 2009 at 4:50pm
once again, u r a life saver

thank you so much =)

now i wat i need to do is study all the formulas that u have taught me, i wanna understand how it works

alright i will start now

thanks again!
IP IP Logged
<< Prev Page  of 3
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.063 seconds.