Reporting on time spent

kathleen_crowley October 3, 2024

I'm trying to query for time spent on issues.  I'm looking at it a couple of ways, and the numbers never seem to match. 

Can someone help with more details on these? 

startOfWeek() - is this a rolling one week period, or is it the previous Monday? 

If I use,  worklogDate > startOfWeek(), will I get the work logged so far this week? 

And if I use, worklogDate > startOfWeek(-1), will I get the work logged the week before? 

Or is there any other suggestion on a better query?

1 answer

3 votes
Walter Buggenhout
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 3, 2024

Hi @kathleen_crowley,

When you use JQL to search for time spent, you always risk to be misled. A Jira filter does not return time spent, it returns issues. And so, if you run a search like this:

worklogDate >= startOfWeek()

 ... that will effectively return all issues with hours logged after the beginning of this week. But, these issues may have hours logged from earlier dates as well and they will show up in your time spent / remaining estimates counts.

Reporting on time spent is an area where I would really recommend taking a look at marketplace apps. While Jira does offer the core functionality to add time spent to an issue, it is not particularly good at reporting on it, not mentioning building some solid processes around that information.

Hope this helps!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events