How to create delayed tasks report

Ariunzaya July 29, 2024

Good day everyone, 

I have a problem with creating a task report. Our team needs to track delayed tasks and have them shown in our reports.

We log our due dates on every task. I tried 'time in status' but no field can show if the task is done by the due date or past due date. 

Does anyone have a solution for this?

3 answers

2 votes
Valeriia_Havrylenko_SaaSJet
Atlassian Partner
July 31, 2024

Hi @Ariunzaya  👋

Welcome to the Atlassian Community!

 

It seems that you have already tried using Time in Status builded by my team. For specifically tracking delayed tasks and showing them in a report, we have developed another add-on called Time Between Statuses. With this add-on, you don't organize statuses in a status group as much as you track transitions between them.

 

3 tools to analyze Cycle and Lead Time in the Jira_3.png

You can set up highlights for values that exceed the permissible level. In this case, you will receive a report based on the warning time limit and critical limit. Also, you will receive email notifications about issues that are close to or already past their due time.

image 99.png

Add-on has 30-days trial version, free up to the 10 users and developed by my SaaSJet team.

I hope this helps 😊

2 votes
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 30, 2024

Hi @Ariunzaya  - Welcome to the Atlassian Community!

I actually do this by add a Delayed status to my workflow. Then I have an Automation rule that rules daily that moves the issue to the Delayed status when it moves past the Due Date. 

José Eduardo Jarrín Sánchez
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!
September 17, 2024

Hi John! I'm really interested in this solution. Could you please explain me how it's done? 

John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 18, 2024

Hi @José Eduardo Jarrín Sánchez  - Welcome to the Atlassian Community!

It's best to create a new question each time for your particular needs, and I would encourage you to still do that for this one. More people will see it. 

But basically, you would add the new status to your workflow, then create an automation rule based on a Scheduled trigger that runs daily. Then add a condition where now() is greater than the Due date. Then add a new action to Transition issue to the Delayed status. 

2 votes
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 29, 2024

Hello @Ariunzaya 

Welcome to the Atlassian community.

Jira does not natively allow you to compare one date field to another date field as part of a JQL filter.

Would you consider acquiring a third party app to accomplish your requirement?

For instance Adaptavist's Enhanced Search has a date compare function that allows you to specify a sub-filyet that compares one date field to another.

https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/jql-functions

I see that you specified you are on the Free plan. The above app supports a free use when your instance is on the Free Jira plan.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
TAGS
AUG Leaders

Atlassian Community Events