Graph of Decreasing Percentages 1

[johnstrang]

To clarify:
I have a database of Fault Cases, each case has a Solution Time (in hours) and I want a graph showing the percentage of cases outstanding, by hour.

X-axis is number of hours, Y-axis is % remaining unsolved

Example at 0 hours, 100% are still open.
38% are solved with 1 hour, so 62% remain
Further 11% are solved within 2 hours, so 51% remain
Further 14% are solved within 3 hours, so 37% remain

I can calculate the % remaining OK by using a Running Total field, but I can't see how to plot that value on a graph.

Can anyone please offer any help?

A further complication is that there are different severities of fault, so each one would require a separate line on the graph.

Many thanks in advance for any suggestions received.

 

[johnstrang]

Sorry, I should have mentioned that this is in CR8.5, directly linking to an Oracle 8i database.

John

 

[SmpTraining]

1. Create a forumla to calculate how many hours it has taken to resolve the fault. This will return 0, 1, 2 ... etc.

2. Group the faults by this new formula field

3. Create another formula for each severiry level such as:
@sev1
if {severity} = 1 then 1 else 0
@sev2
if {severity} = 2 then 1 else 0
@sev3
if {severity} = 3 then 1 else 0

4. Count each of the faults per G1
5. Sum each severity level per G1
6. Use the advanced tab on the chart expert to plot the various values.

This solution wants to show the number of resolved faults rather than outstanding faults so you may need to reverse the subtotal for each G1 by using another formula that subtracts the subtotal fault count from the RF total fault count.

Obviously without your data etc I can't test this properly but I am pretty certain this is the track you should be on.

Steve Phillips, Crystal Consultant

 

[johnstrang]

I've come back to this, and have made some progress following the suggestions by Steve Phillips.
Now I am able to calculate figures like:

Hours Cases Percent
Closed Remaining
0 77 56
1 23 43
2 15 34
.
.
Total Cases = 175
So for 0 hours got 77 / 175 = 44%, therefore 56% remain
For 1 Hour got (77 + 23) / 175 = 57% therefore 43% remain
etc.

What I cannot achieve is a graph of "Percent Remaining" against Hours.
Report is grouped by Hour (@AOT Hours) - formula for calculating "percent remaining" is @pct1:

if Sum ({@sev1}) <> 0 then
global numbervar grp_pct1 := grp_pct1 - ( Sum ({@sev1}, {@AOT hours}) / Sum ({@sev1}) * 100 )

Any thoughts or solutions gratefully received

John