Reporting / Filtering Question

Bill Youngman_h0kkl5

I'm currently using the Time in Status report to generate a report of how long each ticket spent in each status (e.g. Open, In Progress, Resolved, Closed, Paused, Reopened) and what I'm seeing is it appears that each ticket is rolling up the time aggregates to the last person assigned a ticket. It appears that it is now tracking In Progress work as a ticket is reassigned for another person to do work on it.

Whoever has the ticket last gets credit for all the work (for better or worse) and the other people don't. Our management are using the reports for resource tracking - who's doing what and how much time are they spend on it so it is critical that everybody gets credit for the work they are doing.

I could be missing something in this application but in case I'm not how could I write a JQL query filter for this type of reporting?

Thank you,

Bill

Chris Buzon

I think you can use the "Any Field Duration" option to capture how long it was assigned to each person, but you'd have to experiment with the metrics you use to track 'work' during that time.

I just messed around with the Any Field duration and can track a few statistics per person, but we don't use time tracking on our projects, so I am not 100% sure it will work unless your team is very good about updating tickets as they work on them.

TLDR, try "any field duration" in the TIS app itself, found under Apps (next to the Create button). I find that to be the easiest interface to explore, then use that info to create a dashboard with the metrics you need