Count Time Spend by a User on a Ticket

Question

I was trying to find a way to get time spend by a user in my jira. The project DOVE has 8 people working on it and MULTIPLE people loggs time on a single ticket regardless of the assignee.

Here is the scenario:

Ticket DOV-123 is Opened by Jake and assigned to Riya. The ticket was worked by Riya and Lima. Bothe Riya and Lima logged their time in it. And there are several tickets they both works together. I want a query to find the time spend by Lima in the current month. I got a sample

worklogAuthor = Lima AND issueFunction in aggregateExpression("Total tracked", "timespent.sum()" by currentUser()) AND worklogDate >= startOfMonth()

But this give the combined "Time Spend" of both ladies. Can you please help me to extract the time spend only by "Lima"

Thanks in advance!

/SM

Sethu_Madhavan · Answer

Ah! that's really hard to know!

Alexander Eck [Tempo] · Answer

Hi,

you won´t get that information from a JQL since it only displays a list of issues.

You would need a time reporting add-on to achieve that.

BR