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: