Crystal 8.5 Grouping calls by the Hour

[christinetjx]

Somewhere in this forum, i did find a similar question and that is where i got pieces of the formula i have posted below.

I work in a call center and would like to create a report that displays the number of calls logged by the hour.

So total calls on 12/1/04 between 6am - 7am would display under the Group 7:00; Calls between 7am - 8am display under the group 8:00, etc. Something like this:

Time # Calls
7:00 759
8:00 980

I tried using the formula below (i based it on another formula that was listed in the forum) but it does not work. I am not even sure how to 'end' the formula (what the 'then' piece should say and where to place it)...

if {V_incidentsm1.open_time}> 12:59 and
{V_incidentsm1.open_time} < 2:00
1
else
if {V_incidentsm1.open_time} > 1:59 and
{V_incidentsm1.open_time} < 3:00
2
else
if {V_incidentsm1.open_time} > 2:59 and
{V_incidentsm1.open_time} < 4:00


Once I have this information, my boss would like it displayed as a bar graph. But i'll deal with that when i get there.

Any assistance is greatly appreciated.

 

[lbass]

You could create a formula:

datetime({table.date},{table.time})

Then insert a group on this and choose "Print on change of hour." If you want only to display the time, you can use the customize groupname feature->use a formula->enter:

totext({table.time},"hh:mm")

-LB

 

[christinetjx]

This helped!!! Thank you so much!