Count based on multiple variables

[dacards]

Crystal v9.2

I have data (like below) where I'm trying to get a count for each technician on issues submitted, resolved, closed. Problem I'm having is that any one tech could qualify for one or all three variables. And the values change as the report is run (maybe a tech is no longer with the group or was on vacation) so thanynes may not appear on the report next time it is run(and someone else may appear).

Submitter Resolver Closer
bgay rwilliams8 dderda
thaynes abrown11
dschelich ediehl ediehl
dschelich dschelich
thaynes dderda dderda
jarmour jarmour jarmour

I'd like to see data results similar to this:

Technician Submitted Resolved Closed
bgay 1 0 0
thaynes 2 0 0
abrown11 0 0 1
dschelich 2 0 1
dderda 0 1 2
jarmour 1 1 1
rwilliams8 0 1 0
ediehl 0 1 1


As always thanks for your help.

 

[lbass]

Please show us the fields you are working with. Is there a field that returns "closed", "resolved","submitted"? Is there only one name field (technician) or are you saying there are separate name fields for each status?

-LB

 

[dacards]

Thanks - let me try to clarify.

When the report is run you select a date parameter and a work group parameter. My record selections is as follows:

({Closed Time} >={?Start Date}
and {Closed Time} <= {?End Date}) and
((({Work Log}like'*'+({?Work Group }&" - Group")+'*')or
{Submitter Primary Group}={?Work Group }or
{Resolver Primary Group}={?Work Group }or
{Closer Primary Group}={?Work Group }))

My data then contains the following fields:

{Trouble.TT Request ID}
{Resolver Primary Group}
{Resolved By}
{Submitter Primary Group}
{Submitter }
{Closer Primary Group}
{Closer }

Since I am only concerend about the one group I requested i set up formulas for each (Submitter Group, Resolver Group, and Closer Group) like:

if {Submitter Primary Group}={?Work Group }then
{Submitter}

This leaves me with the data I entered in my first post. Hopefully this helps out - Let me know if more info is needed.

 

[lbass]

Do you have a separate table that includes all of the staff names instead of just in the fields you note above?

-LB