Pivot table of how many incidents each of my team have worked (updated) by Priority
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-17-2016 05:07 PM
I would like to create a report that is a pivot table showing the number of incidents each of my team has worked on with counts by priority. This should include any ticket they have updated, by only a count per incident, not per update. ( If Joe Smith updates INC000123 four times, and INC000124 twice the count should only show as 2). We often end up passing on tickets to others and they don't end up assigned to us and I need to show the number we have worked on by person....
An example would be:
Name | Priority 1 | Priority 2 | Priority 3 |
---|---|---|---|
Joe Smith | 2 | 0 | 5 |
John Doe | 1 | 2 | 2 |
Jack Hammer | 0 | 1 | 8 |
Willy Wonka | 2 | 2 | 4 |
Can someone show me how to set this up?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-02-2016 12:12 PM
That is true. So the way around that is to build a custom Metric that gets triggered by a business rule. Here's another post where I explain: Re: Is there a way to report on audits in a way that is efficient (or a way to report on user action...