Trying to create chart with "Count" formula

[Oglesbay]

Hi all.

First of all, I'm using Crystal XI. What I have is a database of class evaluations. There are three questions that are important to us and they can grade us from 1 to 5 (5 being the highest).

What I want to do is create a formula that counts the evaluation if it is a 4 or higher. I've already created something like this:

if {tbl2004WebEvals.CourseActivities} >= 4 then 1

I then sum the previous forumla and divide it by the total number of evaluations to give us our "Pass" percentage. So as of now I have 6 formulas for the three questions (two each).

The problem is though, when I use the formula that divides the sum by the total, it loses all concept of time and I cannot break my chart into Months, Weeks, Quarters or any other time frame (except "Year").

Does anyone have some tips on what I can do to have all this work in one formula that doesn't loose the concept of time? Thanks in advance!

Chad

 

[lbass]

Please show a sample of data at the detail level that includes the date field as well as the other fields you are using in the chart.

-LB

 

[Oglesbay]

At the detail level, here is an example of my data:

Mickey Mouse 5 4 5
Donal Duck 5 3 4
Minnie Mouse 4 5 3
Goofy 5 4 4

It is grouped by Date and then by class name. The only fields that I am trying to chart are the "Pass" percentages which are the number of evalutaions that are a 4 or 5 divided by the total number of all evaluations.

 

[lbass]

Please add the date field to the detail level, along with the class name. I'm trying to see what the data looks like, not what your report looks like, and please label each field with actual field names.

-LB

 

[Oglesbay]

Sorry about that, here are all the labels:

* Key *
Question 1: {tbl2004WebEvals.CourseActivities}
Question 2: {tbl2004WebEvals.CourseUsefulness}
Question 3: {tbl2004WebEvals.Inst1Objectives}
Course Name: {tbl2004WebEvals.Course}
Date: {tbl2004WebEvals.Date}

Example Detail Line:

1/31/08 (Group #1 - Date)
Microsoft Excel (Group #2 - Course Name)
Mary Smith 5 4 5
John Doe 5 4 3
(Q1) (Q2) (Q3)

I hope I understood you correctly and told you what you wanted to see. Let me know if you need anything else.

 

[lbass]

If you are charting on a monthly basis, you should have a month group in your main report, and then use a formula like this as your summary field in the chart:

sum({@pass},{table.date},"monthly")%count({table.studentID},{table.date},"monthly")

You would also have to add the date field as your "on change of field"->order and select "on change of month".

For charts for other time frames, you would create a separate formula with the correct date condition, and change the date "on change of" interval accordingly. You would also need the corresponding group in your main report, even if suppressed.

-LB

 

[Oglesbay]

lbass -

I tried the formula and created the new groups as you said and it works, kind of. If I am showing a report on just Question 1, then everything is great. However, if I try to put Question 2 and Question 3 on the chart as well, it shows the same data as Question 1. Why is that? Is there some way to show all three questions on one chart by month?

 

[lbass]

If the questions are separate fields, then you would have to add the other questions as separate "show value" fields. Maybe check your formulas to make sure you changed the conditional formula in the sum part of the percentage to reflect the specific question.

-LB