Count Time Spend by a User on a Ticket

[Sanal Karippidi Puthiyapurayil]

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

[Alexander Eck [Tempo]]

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

[Sethu_Madhavan]

Ah! that's really hard to know!