Time Sheet Report by Rich Filter

[Javad]

Hello all,

I have a question about using rich filters. I want to create a table to show how much time is spent on each task for a selected period of time. As an example, when I choose user1 and period 14-day by rich filter controller, then the table is filtered to show all the tasks of user1 that he/she has logged during the last 14 days and show how much time is logged during the last 14 days for each task. I've already done it by the "Rich Filter Result" gadget but it shows all the time spent on the tasks, not the last 14 days logs.

[Walter Buggenhout · Accepted solution]

Hi @Javad and welcome to the Community!

Your observation is absolutely correct. The behaviour you see is because the underlying search in Jira always returns issues. Even though JQL does indeed allow you to search for issues that have worklogs at, before or after certain dates, that search will always return those issues, but also the time spent on those issues outside your search criteria.

If you want to do proper reporting on worklogs, this is an area where you would benefit greatly from adding a marketplace app to your instance that focuses on this area. Both internally and as a Solution Partner, we usually work with Tempo Timesheets for this, as it does not only allow you to do proper reporting, but it also has a lot of process features to help you streamline time tracking across your organisation. But if you check out the marketplace, you'll quickly find out that there are plenty of time tracking and reporting apps that may help you get what you need.

Hope this helps!

[Javad]

Thanks for your help.

[Mary from Planyway]

Hi @Javad,  

A warm welcome to you!  

As you've correctly noticed, Jira’s filters are tied to the dates set within the issues themselves, which can sometimes make it tricky to get the exact results you need. 

If you're looking for a more tailored solution to generate the report you're after, I recommend giving Planyway a try! With Planyway, you can easily set a custom date range for your report, choose the relevant projects, and even group the data by users. This will give you a clean, detailed overview of the work logs created by each user during the selected period, helping you see exactly what you require and export the data for further analysis. 

Feel free to reach out if you need more info or help setting it up!

[Rahul_RVS]

Hi @Javad 

Welcome to the community !!

For detailed worklog reporting if you would be interested in a mktplace app, you may want to try out our mktplace app. Other option is to use Jira Rest API's to build your own custom solution.

Worklogs Time Tracking & Timesheets

With this add-on, you can easily view time entries for multiple issues day wise grouped by in a single view. Also for your requirement as shown in the screen grab below, you can filter the time spent between your sprint date range.

(Disclaimer: I work for RVS, the vendor for this app)