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.

×
Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Monthly Report: Date and tasks that were in progress on that date

Nikita Simakov
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 5, 2023 edited

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?

5 answers

0 votes
Valeriia_Havrylenko_SaaSJet
Atlassian Partner
December 14, 2023

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.

Assignee Time.gif

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 😌

0 votes
Emre Toptancı _OBSS_
Atlassian Partner
December 9, 2023 edited

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

tisCloud_StatusDuration_LeadTime_with Estimates.png     tisCloud_AssigneeDuration.png

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). 

tisCloud_StatusPerTimePeriod.png     tisCloud_TimePeriodPerStatus.png

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.

Gadget_AverageStatusDurationByComponent.png   tisCloud_StatusDuration_LeadTime_Chart.png  tisCloud_IssueView_Data.png

Timepiece - Time in Status for Jira

EmreT

0 votes
Tanya _DevAcrobats_ December 8, 2023

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.

Issues_in_progress_over_time_Perfromance Objectives for Jira.png

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

0 votes
Deniz Oğuz - Starware December 7, 2023

Hi @Nikita Simakov 

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. 

0 votes
satish venkata December 5, 2023

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.

Nikita Simakov
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 7, 2023 edited

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

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, atlassian government cloud, fedramp, webinar, register for webinar, atlassian cloud webinar, fedramp moderate offering, work faster with cloud

Unlocking the future with Atlassian Government Cloud ☁️

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
AUG Leaders

Upcoming Jira Events