How can I filter out time tracking for the month?

Question

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.

Deniz Oğuz - The Starware · Answer

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.

Adaeze_Jude_HEROCODERS · Answer

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:

Iryna Komarnitska_SaaSJet_ · Answer

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: