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 Next >>
Author Message
guan
Newbie
Newbie


Joined: 06 Aug 2009
Online Status: Offline
Posts: 17
Quote guan Replybullet Posted: 06 Aug 2009 at 5:44pm
i manage to solve the problem by using this formula
datetime(date({Qlog1.Call Date}),time({Qlog1.Call In Time}))

 however, the chart is now showing everyday and everyhour
umm.. forexample   13/07/09 -- 8am, 14/07/09 -- 9am, 15/07/09 -- 10am and so on

haha i think its the formula?


IP IP Logged
guan
Newbie
Newbie


Joined: 06 Aug 2009
Online Status: Offline
Posts: 17
Quote guan Replybullet Posted: 07 Aug 2009 at 5:53pm
hi can anyone else help? thanks
IP IP Logged
guan
Newbie
Newbie


Joined: 06 Aug 2009
Online Status: Offline
Posts: 17
Quote guan Replybullet Posted: 09 Aug 2009 at 11:47am
up
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 09 Aug 2009 at 1:26pm

WHat field did you use for the SUmmary and what is the SUmmary set to?

IP IP Logged
guan
Newbie
Newbie


Joined: 06 Aug 2009
Online Status: Offline
Posts: 17
Quote guan Replybullet Posted: 10 Aug 2009 at 7:34am
the field i set to is "no." and its set to distinct count.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 10 Aug 2009 at 7:46am

This is hard to diagnose without seeing the data and your set up so I need to ask a few more questions...

1. Are you filtering the report data at all (or do you need to and are not)?
2. Do you want more than one day of data to appear? If so do you want a different chart poer day?
3. Or do you want to collapse all of the days into one and just show the hours in your chart regardless of that date?
4. Can you post sample row level data so i know what I am dealing with at a data level?
IP IP Logged
guan
Newbie
Newbie


Joined: 06 Aug 2009
Online Status: Offline
Posts: 17
Quote guan Replybullet Posted: 10 Aug 2009 at 9:31am
do you want me to upload the files here?

basicaly i wanna show for exmple on 1st of june,  the number of calls from 8am to 6pm in 1 hr interval. you told me that 30mins interval will be tricky and i should use the build in function which is the 1hr interval.

it would be good if i could show 1 chart per day with the 1hr intervals from 8am to 6pm

heres the sample row of data

No.             Call Date       Call In Time      Caller Name       Employer ID
1                14/7/2009      9:00AM            Rebecca             443432
IP IP Logged
guan
Newbie
Newbie


Joined: 06 Aug 2009
Online Status: Offline
Posts: 17
Quote guan Replybullet Posted: 10 Aug 2009 at 9:37am
hey DBlank, i will see your reply tmr morning
its already 1230am here, i need to wake up for work tmr

thanks again and sorry for the trouble
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 10 Aug 2009 at 2:52pm
OK here is what I would do.
Create date parameters to filter the overall report dates (if needed based on size of data).
1. Create a formula field for the for the date as "DAte Group" :
date({Qlog1.Call Date})
2. Group on this formula and change to "For each Day".
3. create a time formula as "Time GRoup":
time({Qlog1.Call In Time})
4. create a Group header1B.
5. Go into your existing Chart and change the "On Change of" field to the  @TimeGroup formula field.
6. Drag the chart to the GH1B
Check it out and see is working as you want per day (one chart per day group header).
 
Youc an also exclude data using your select expert with:
time({Qlog1.Call In Time}) in TIME(08,00,00) to TIME(18,00,00)
 
If you really want this to be every 1/2 hour you can write a formula to convert your time field to be every half hour and group on that instead but it will be a long statement...
if time({Qlog1.Call In Time}) in TIme(08,00,00) to Time(08,30,00) then time(TIme(08,00,00) else
if time({Qlog1.Call In Time}) in TIme(08,30,01) to Time(09,00,00) then time(TIme(08,30,00) else
if time({Qlog1.Call In Time}) in Time(09,00,01) to Time(09,30,00) then time(TIme(08,00,00) else ...
 
 
If I come up with a better formula for the 1/2 hour I willpost that for youlater but that is easy to swap out if the rest of it works


Edited by DBlank - 10 Aug 2009 at 2:53pm
IP IP Logged
guan
Newbie
Newbie


Joined: 06 Aug 2009
Online Status: Offline
Posts: 17
Quote guan Replybullet Posted: 10 Aug 2009 at 5:43pm
DBlank it works!, u r a real genius! thank you so much for your time and patience in helping an idiot like me.

thanks!!
IP IP Logged
<< Prev Page  of 3 Next >>
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.046 seconds.