Pivot table of how many incidents each of my team have worked (updated) by Priority

incidentguy
Kilo Explorer

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:

NamePriority 1Priority 2Priority 3
Joe Smith205
John Doe122
Jack Hammer018
Willy Wonka224

Can someone show me how to set this up?  

5 REPLIES 5

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...