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

0 votes
Answer accepted
Jack Brickey
Community Champion
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

Suggest an answer

Log in or Sign up to answer