How can I filter out time tracking for the month?

[Chinu]

We are currently using sub-tasks to track time on parent stories. I would like to filter out the time logged by month. I'm currently playing around with JQL; project = XXXX AND type in (Story, Sub-task) AND worklogDate > 2023-02-01 AND worklogDate < 2023-02-28 

It seems that this query brings up the total time recorded in the sub-task worklog, not the dates I specified., am I missing a parameter or a boundary condition I don't know about?

It would be greatly appreciated if anyone can help.

[Adaeze_Jude_HEROCODERS]

Hi @Chinu ,

Third-party Apps like Clockwork Automated Time Tracking & Timesheets Free provide you with detailed reporting.

The great thing about Clockwork is that you can use it out of the box - just install, allow for worklogs to be indexed and they will show up in Timesheet view, where you can select the time range and many other criteria to determine what is included in your report.

As shown:

[Trudy Claspill]

Hello @Chinu 

JQL retrieves issues, not worklogs. What you are getting are issues that includes a worklog within the date range you specified. 

How are you viewing the total time in these results? If you are showing the Time Spent field, that will show total time spent for the issue. It doesn't not calculate Time Spent for individual issues based on criteria in the JQL statement.

Jira's native functionality provides only rudimentary reporting on time logged on issues. You will likely need to look at a third part app if you want to create more sophisticated reporting of subsets of time logged.

Are you open to using third party apps to solve this reporting need?

Are you using native Jira time tracking or have you added a third party time tracking app like Tempo Timesheets?

[Deniz Oğuz - The Starware]

Hi,

"worklogDate > 2023-02-01 AND worklogDate < 2023-02-28" JQL query clause finds all the issues that have at least one worklog in this period. But the problem is, these issues may have other worklogs that are not within this time range. If you are using a 3rd party application it should have a period selection feature other than the time range specified as a part of the JQL query. 

If you are using a time-tracking application like WorklogPRO, you should also specific date range too. 

[Iryna Komarnitska_SaaSJet_]

Hi @Chinu 

I want to draw your attention to an app my team has developed.

Cost Tracker for Jira Cloud allows you to not only analyze the pledged time by tasks, projects, sprints, etc. But also calculate its cost depending on the time logged by the performer.

It is possible to enter and track expressions and generate cost reports. Since this is sensitive information, the administrator can manage access in general. Also, you can distribute certain cost reports only to some team members.

Here is a 30-day trial for you to check if the app is good for you! For teams of up to 10 users add-on is free.

In our articles, we gave useful tips on how else you can use the app:

• Tracking Project Cost in Jira
• The Cost of an Issue in Jira
• How to get your team meeting cost in Jira
• Managing Sprint Costs in Jira
• Cost tracking for marketing teams in Jira

Example:

[Madhu_RVS]

Hi @Chinu 

To add to Trudy's response, an app can help you retrieve time logged on issues.

If you would be interested in the same, you can try out our add-on

Worklogs Time Reports

The app provides the following features.

• Worklogs Report :
  • Create reports for time entered by your team members
  • Filter/Categorize/Group By your worklogs data
• Timesheets : View/Enter time spent for multiple issues and multiple days from a single screen
• Dashboard gadgets

 Disclaimer : I work for the vendor who built this app