How to Calculate % of Calls Completed

[hyde42]

I need to create a Crystal Report (XI) that will show the number and percent of calls completed within the same day, within 10 days, within 30 days and greater than 30 days.

The two fields I have to work with are:

Service Date (when call was placed)

Add TS (when call was completed)

Any help would be greatly appreciated! Heidi

 

[fishymetrics]

create a formula for duration and status
//@Duration
{complete_date} - {open_date}

//@status
if isnull({complete_date}) then "Still Open" else
"Complete"

make a crosstab with @status columns and @duration in rows
Summarized Fields:
Count of {open_date}
Percentage of total count of {open_date}



for @duration click Group Options-Specified Order-NEW-
make Group Name "Same Day" (no quotes needed)
value Is Between 0.0 and 1.0
press OK
NEW
make Group Name "10 Days" (no quotes needed)
value Is Between 0.0 and 10.0
press OK
NEW
make Group Name "30 Days" (no quotes needed)
value Is Between 0.0 and 30.0
press OK
NEW
make Group Name ">30 days" (no quotes needed)
value Is greater than 30.0
press OK
NEW
make Group Name "bad dates" (no quotes needed)
value Is less than 0.0
press OK

OTHERS
check Put all others with groupname 'Others'
press Ok

crosstab will look like;

Still Open Complete Total
Same day count count count
% % %
10 days count count count
% % %

and so on....

"Other" should only be Still Open status
"bad dates" will identify the inevitable reversed dates and poor data input.

 

[hyde42]

Thank you, fishymetrics! This is phenominal!

I do have a question though...so I have 94% Same Day, 4% 10 Days, 0% 30 Days and 0% >30 Days and no Bad Dates and No Other...what happened to my other 2%? Could it be that the numbers are so small that they don't come out to 1% for the 30 Days or >30 Days categories?

My numbers look like this:

Total = 11549 = 100%
Same Day = 10893 = 94%
10 Days = 539 = 4%
30 Days = 78 = 0%
>30 Days = 39 = 0%

Thanks, again! h

 

[fishymetrics]

yes.
Try adding a decimal place to the percentage...formatting...

 

[fishymetrics]

hmmmm....?
never noticed that before...
it appears that it truncates the decimal and does not round up.
can't change the formatting for decimals on the %.

 

[hyde42]

Thank you, again, fishymetrics! Your assistance was very helpful!! h

 

[lbass]

fishymetrics,

That is why I often use variables in the formatting formula areas to create the percentages which are then created in a calculation and shown using the Display String function.

-LB