The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to know timespent on a particular date?

prthp
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 20, 2020

JIRA query to display time spent on a particular day.

For example, there will be multiple tickets user works on a particular day. User logs work say 3h for 1 ticket & 5h for another ticket.

How can I display the sum as 8h logged on that particular day using JIRA query?

Below query lists the 2 tickets in this case, but I need to know how to sum the time spent:

worklogAuthor = currentUser() AND worklogDate = "date"

Below query displays today time spent for 2 tickets but I need to know timespent on particular date:

issueFunction in aggregateExpression("Total Points", "timespent.sum()")

 

1 answer

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes
Answer accepted
Jack Brickey
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
August 20, 2020

Not OOTB. I use Time Reports addon for this but there are other offerings in the marketplace 

prthp
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 20, 2020

Thank you