Drill Down/Counts

[dwayne49]

I have a list of people from the Help Desk team. I need to create a report that will give me the number of tickets that were done by each group and by each person in the group (drill down). From there I need to do a count of tickets that were met, tickets that were missed, and a percentage of tickets that were met.

So far I have this:

#of tickets Avg Hours to Resolve
Desktop-Support ATL
Severity 1 1 8.56
Severity 2 10 100.94
Severity 3 139 118.98

What hints can you give me

 

[synapsevampire]

Post the fields available for accomplishing this, and your software version.

In general I guess you'd have a date whena ticket was opened and when it was closed, oerhaps in one row, perhaps in two, so you's use the date to figure it out.

I suggest that you post technical information in lieu of descriptions, and seek solutions rather than hints, such as:

Crystal version
Database/connectivity used
Sample of the data returned
Expected result

-k