How can I Split users into groups and count group performance

[javedi]

Hi

I have a report which produces the number of letters each user has written. I'd like a formula to split the two teams of users into two groups and show how many letters each group has produced.

For example,

group A - 17 Letters
group B - 20 letters

Does anyone know of a formula that could show these results?

Many thanks,
Javedi

Crystal 10/SQL server 2005

 

[hilfy]

Is there a field in your data that identifies which group the user belongs to?

If so, create a group on that field in your report and then add a summary formula to count the number of letters.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[lbass]

Or if you don't have a field, but you know who belongs to what group, you can hard code it:

if {table.user} in ["Jack","Jill","Janet"] then
"Group A" else
if {table.user} in ["John","Joe","Frances"] then
"Group B"

Insert a group on the formula and then then insert a summary on some recurring field to get the desired count of letters at the group level.

-LB

 

[javedi]

Hi hilfy/lbass

Thanks guys.

I don't have a group field but do have a field for individual users.

The report already groups by users and lists all the letters they have printed under their usernames. Not all users belong to a group.

I tried gouping on the formula and inserted a count but this showed counts for users not the total for each group.

Any more idea's?

 

[lbass]

You should be inserting a group on a formula like mine, but change it to:

if {table.user} in ["Jack","Jill","Janet"] then
"Group A" else
if {table.user} in ["John","Joe","Frances"] then
"Group B" else
"No Group Assignment"

We don't know what fields you are working with. If you have a letterID field, then you could insert a distinctcount on this field at the group level. If you have a database field that already shows a summary count of letters, insert a sum on that field at the group level. If this doesn't help, please show label your fields and show a sample of data at the detail level.

-LB

 

[javedi]

Hi lbass

here's sample from user alow. She is one member of Team A. ideally all i need to do is show how many letters each team has printed. if it is possible i can place a formula in footer or header to show the totals for each team, without using groups.

user no of letters printed
alow 13
Wednesday, 3 December, 2008
PCNID RequestedBy Name PrintedDate status
65001007 alow No Valid Permit RR 03/12/2008 09:23:57 Print Success
55148789 alow Load Rest 02 RR 03/12/2008 10:07:42 Print Success
55148789 alow CCTV LoadRest DiscRR 03/12/2008 10:31:16

Would it be possible to include a count of the number of letters each team has written in your formula.

Thanks lbass

 

[lbass]

Please explain what your current group structure is. Why don't you want to insert a group based on the teams? In your sample above, what is the summary you used to get 13?

-LB

 

[javedi]

I have grouped on the users, in the details section showing all the letters printed.

The two groups are in order;

CorrespondenceRequestLog.User
-> Documents.PrintedDate

The summary is distinct count based on PCNID. I only pasted 3 records from the 13 hence the inaccuracy.

I tried grouping on suggested formula and it showed the groups the users belong to as specified;

alow - Group A
psmith - Group B
bcharles - Group A

What i'd like to achieve is

Team/Group A wrote 14 letters
Team/Group B wrote 17 letters

anywhere in the report for a quick glance for the report readers.

 

[lbass]

You have to make the formula your Group #1, NOT group #2. You can do this by going to report->group expert and using the arrow key to change the group order.

-LB