Reporting question, time spent of tickets by assignee group membership

[Blair Calvert]

Hi Folks,

I'm looking to create a report indicating how much time is spent on tickets per service team member, per office for our monthly reporting.

Set up is 3 team members (me & two others) looking after 230 staff across 6 offices.

I'd like to be able to report on how much time is spent on tickets for each office, per support team member.

Customers are tagged with their office location in their "group" membership.

I can get reports on the quantity of tickets and the Time to Resolution (avg.) but not a quantum of time spent on tickets.

Any ideas?

TIA.

Blair

[Pramodh M]

Hi @Blair Calvert 

Heres the JQL

worklogAuthor in membersOf("") AND assignee in membersOf("") AND customField in member of("customer-group")

You could exclude assignee part of not needed or go with your JQL to get worklog authors

But for getting the customers the last part will work

Thanks