Help with line Chart 2

[mmaz]

Hi! I'm trying to display 3 lines on a line chart. The x-axis is % of calls and the y-axis shows calls grouped by date and further grouped by time interval (< 20 sec, < 30 sec, other).

Here's what I want to display:

1st line: less than 20 seconds
2nd line: less than 30 secons
3rd line: others

I created a group for the date (showing each day), and another one for time interval (arrival_time - create_time). The order for the second group is specified (<20, <30 and >30).

My problem:

My 1st line is accurate, but my 2nd line shows data between 20 and 30 seconds instead of 0 to 30 seconds. My 3rd line is completely off the chart, showing 100%.

How can I display accurate 2nd and 3rd lines? Is this possible?

I would be grateful for any help! Thank you in advance!

Marie

 

[kenhamady]

First, read the FAQ on what to include in your question. With charts the Version you are using is critical.

You have 2 problems:
First, with specified order all records are in only one group at a time. It appears that your first 2 groups overlap so the record only counts in the first one it qualifies for.

Second, it appears that you are using a Crystal percent-line chart. Percent-line charts always stack up to 100%, so the top line is always 100% (check the little picture). You cant use this type if you want to compare percentages against each other. This type of chart is for showing components of a mix.

What is confusing is that you want to count calls under 20 in the under 30 group as well, but the others are separate?

So if you had 3 calls, 15, 25 and 35 you would want to calculate:

33% under 20
66% under 30 and
33% others?


Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[mmaz]

Hello Ken! Thank you for your quick reply. I'm using version 8, ODBC connection, no programmimg.

You got it right with the 3 lines. My first two should overlap and my third should not. I understand why I can't use a percent-line chart, but if I don't, is it possible for me to count calls under 20, under 30 and others?

Thank you!

 

[kenhamady]

It can be done, but it will take some homework on your part.

Use three separate formulas to put a 1 on the details for each record that meets the three different conditions.

Create a total of these formulas to get the number of records in each group meeting each condition.

Then use these totals in three other formulas to calculate the three percentages you need. These should print percentages at that end of each group.

Once these percentages are calculated, you can create a line chart (don't use stacked or percent line). You will have to use the advanced option on the data tab; on change of the same group as the report; with all three percentages formulas moved to the show values box. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[mmaz]

Thank you for your help, Ken. I really appreciate it.