Just a heads up: On March 24, 2025, starting at 4:30pm CDT / 19:30 UTC, the site will be undergoing scheduled maintenance for a few hours. During this time, the site might be unavailable for a short while. Thanks for your patience.
×I want to optimize the process of filling monthly timesheets. For this, I would like to get a report in the following format:
* Date
* IDs of tasks that were assigned to me and had "In Progress" status in JIRA on that day
Is it possible in JIRA?
Hello @Nikita Simakov 👋
For assignee time report, I recommend you try Time in Status for Jira (Cloud).
It generates 7 types of status time reports including the Assignee time one. It shows how long each assignee has been working on each issue. So you can easily track how the workflow of each assignee goes and whether some delays occur.
You just need to choose the date ranges and then export to the Excel file.
This add-on is developed by my SaaSJet team and has a 30-day free trial version. and free up to 10 users.
Hope it helps 😌
Hello @Nikita Simakov ,
You can use JQL query like...
project = ABC and assignee was john.doe
... to filter our issues that were assigned to a specific person in the past.
We have an app that might help you in another way. Our team at OBSS built Timepiece - Time in Status for Jira for requirements similar to this. It is available for Jira Server, Cloud, and Data Center.
Time in Status mainly allows you to see how much time each issue spent on each status or each assignee.
For your specific case, Time in Status has Time-Period per Status and Status per Time-Period reports. These reports can show how much time each issue spent in each status in each time-period (like months, weeks, or days).
Using these reports with a JQL query like "assignee was currentUser()" you can easily find the issue you worked on in a particular time-period.
The app calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows and you can get reports on your past issues as well. It supports both Company-Managed and Team-Managed projects for Jira Cloud.
Time in Status reports can be accessed through its own reporting page, dashboard gadgets, and issue view screen tabs. All these options can provide both calculated data tables and charts.
Timepiece - Time in Status for Jira
EmreT
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello, @Nikita Simakov ,
I believe achieving your desired report in native Jira might be challenging. However, the Performance Objectives app offers a solution with its 'Number of issues over time in status' metric.
It allows you to count issues in specific status(es) over a custom-defined date granularity (hour/day/week, etc.) on Jira dashboard. Additionally, you can choose whether the report shows issues in this status at the end (snapshot) or at any time during the chosen granularity (full time), in your case - by day.
I am applying a sample visualization. You can visualize this report with different types of charts (bar, line, area, etc., in addition to the table view). You can preview issues in Jira navigator. Another option (if reporting on 100 issues max) is to stack issues by Issue key.
As a team member behind the app, I encourage you to explore its features through a free trial. Also, the app is free for cloud teams with up to 10 users.
For any questions or support needed, please don't hesitate to reach out. To gain a deeper understanding, consider scheduling a demo.
Best regards,
Tanya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I don't think you can get list of issues that were "In Progress" status on a specific day. If you find a way, please let us know too.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Project = ABC and Status= " In Progress" and Assignee= "Your name" and created <= -30d,
which will gives you last 30 days tickets assigned to you which are in inprogress.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I don't need a list of current items in progress, but rather a timesheet table in a following structure:
Date | Tickets
01.01.2023 | TASK-1, TASK-2
02.01.2023 | TASK-2
03.01.2023 | TASK-3
04.01.2023 | TASK-3
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Atlassian Government Cloud has achieved FedRAMP Authorization at the Moderate level! Join our webinar to learn how you can accelerate mission success and move work forward faster in cloud, all while ensuring your critical data is secure.
Register Now
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.