Help with a chart, tickets assigned to a user over time

andrew.pass

Hi,

Hoping someone can help me figure this out please,

I'm trying to do a report that I can use to give me a graph representation of how many times a user may have been assigned to different tickets in any different week.

So for an example - 

• User A are assigned to a ticket on Monday,
• That ticket is then re-assigned to User B,
• User A is assigned to a second ticket on Thursday

Report would show they've been assigned to two tickets that week.

Thanks

Matthew Lempitsky

Hi Andrew, you could query the Issue History table for this information. This will store a historical record of all field changes. If you query the table for the field name assignee, you will be able to perform a count of issues assigned to users. 

Here is a very basic approach to begin looking at that information: