2

I need to create a report telling how many cases were handled by support personnel. Each case can be handled by one or more support engineers and all of them are added to this case's team. So, what I want is to get the list of engineers along with the number of cases in whose teams these engineers are included. For example:

Engineer         Cases #
Bill Smith       12
John Miller      25
Garry Mitchel    9

Is this possible?

1
  • If 3 users worked on same case - you'd expect same case to be counted 3 times? What have you tried so far? Looks like a summary or matrix report on Case Team Member object would be a good start... I don't think there's a standard report for that but you can easily create custom report type "Cases with or without Team Members" or something like that.
    – eyescream
    Commented Jun 5, 2014 at 6:46

1 Answer 1

0

I have found a way to do this. First of all, you need to create a new report type: enter image description here

After this, create a new report with the matrix format based on this report type. Use the following fields and filters in this report: enter image description here

That's all. However, this report does not allow filtering on a case team member role.

2
  • I'm new to reports can you help me like how differentiate january march like columns in reports
    – Pavan tej
    Commented Mar 16, 2016 at 14:20
  • @Pavantej, point the mouse pointer over the Date/Time Opened column name and an arrow button will appear at the right side of this column header. Click this button and select a needed option from the Group Dates By menu. Commented Mar 18, 2016 at 18:02

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .