Charting Issue

[khdavis]

HI! I using Crystal 10. Database is Oracle. (My Crystal is not very advanced so please bear with me.)

I'm creating a chart that's needs to include a line that would reflect the daily average for the entire reporting period.

My data includes the following:

Ticket#
Criticality
Start Date

The criticality can be Level 1 through Level 4.

For each criticality I need to assign impact points, such as:

Level 1 = 100 points
Level 2 = 25 points
Level 3 = 5 points
Level 4 = 1 points


Example (from database)
Start Date Ticket# Criticality
4/10/2007 1 Level 1
4/10/2007 2 Level 3
4/10/2007 3 Level 4
4/11/2007 4 Level 4
4/11/2007 5 Level 1
4/11/2007 6 Level 2
4/12/2007 7 Level 3
4/12/2007 8 Level 4
4/12/2007 9 Level 4

I'd then need to assign and summ the points.
Start Date Ticket# Criticality Impact Points
4/10/2007 1 Level 1 100
4/10/2007 2 Level 3 5
4/10/2007 3 Level 4 1
4/11/2007 4 Level 4 1
4/11/2007 5 Level 1 100
4/11/2007 6 Level 2 25
4/12/2007 7 Level 3 5
4/12/2007 8 Level 4 1
4/12/2007 9 Level 4 1

My daily average would then be the sum of points (239) divided by the number of (unique) days, wouch would be three (3).

Daily average = 79.6

I have not been able to figure out how to do this in Crystal. Any suggestions?

 

[Dan3D]

If no one proposes a better solution, you may want to look at CRChart, the add-on library. It has much better support for mapping user-lines to a field at runtime. In particular look at the @Y and @YSZN macros.

-Dan

disclaimer: this product costs money. I work for the company that makes this product.

Dan Weingart
OEM Technical Manager
Three D Graphics, Inc.

http://www.threedgraphics.com