Filter out all but best scores

[peterb58]

Crystal XI SP4 against Sybase 9.02 on Win XP

I am working on a Call Centre database and I have to produce some stats for a given period. We a focussing on the response time of the staff to take a call once it has been added to the waiting list. The table I am linked to has the Notification Time and the Response time ( secs ).
We need to see if we meet targets for calls responded to in <30sec and <60sec by Hour, Day and the report period.

I have created two groups, Notification Time by Day and Notification Time by Hour. I also have a number of running totals showing the number of calls in the <30 and <60 bands.
What I need to do now is show only the best response figures for any single hour/day during the report period.

The original report had the following data displayed:-
Best Hour of Day within report Period under 30 sec:- XX%
Best Hour of Day within report Period under 60sec: XX%
Best Day within Report Period under 30sec: XX%
Best Day within Report Period under 60se: XX%
etc etc.

I have all the relevant figures there, but how can I filter out everything but the ones I want.

thanks

Pete

 

[lbass]

So you are comparing every day/hour combination with every other (as opposed to comparing the same hour across days with other hours across days)?

Not sure how you are calculating the percentages, but you could display the best ones (highest percentages), by using variables like this:

whileprintingrecords;
numbervar maxhr30;
if {@yourpercentage} > maxhr30 then
maxhr30 := {@yourpercentage};

Place the above formula in the section where the percentage is calculated. Then in the report footer use a formula like this:

whileprintingrecords;
numbervar maxhr30;

-LB

 

[peterb58]

LBass

Thats the sort of thing I was looking at, but could not get the syntax quite right. All I got in my footer was True or False.

The percentages are being calculated from the total calls per period. e.g in a single hour we may get 120 calls, 95 of which are <30 and 110 are <60. Those calls >60 are simply ignored. The target is about 90% of call <30 and 98% <60.
The same principle applies to day and week.

All I need to show is the highest figure for each period, if they do the report over a long enough period, everything is likely to be 100% anyway!! But it is not my job to question their needs!!
It is just a booster to show they can hit targets. Personally, I think the lowest figure should be shown and then they have some improvement to work on.

Will try thisout when I am back in the office.

Many thanks

Pete