Call Tracking by hour help

[PlaidEmp]

Trying to setup a scattergram report

The report is supposed to show calls per day over calls per hour incraments. This will give me an average number of calls per hour. I can only get it to do calls per day and it will show each call placed(not hourly but by the time it was logged). This way is way to big.

Any help would be grately appreciated.

Thank you,

 

[LindaC]

I would create a formula to group the hours. ie

if yourtbl.hr > 12:59 and
yourtbl.hr < 2:00
1
else
if yourtbl.hr > 1:59 and
yourtbl.hr < 3:00
2
ect...

I would then group on that formula field and place totals in the group footer and supress the details which you are getting now.

LindaC
lcastner@co.orange.ny.us

 

[PlaidEmp]

You can handel AM PM by using 24 hour time?
This is a 24-7 call center.

 

[LindaC]

That is the way I would handle it. Break up the hours into 24 groups; then total in group footer; display group footer and supress details.

Good Luck!!!!


LindaC
lcastner@co.orange.ny.us