nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Auto calculate date between statuses

Prabhu Prabhakar

Hi All,

I've a request to set 5week time to complete a task and each step have to set up a fixed date to complete the status.

Eg: T-5 to complete a Task

Open T-5
In Progress T-3
Done T-1
Close T

I need to auto calculate the dates for T-1, T-2 weeks etc.

I need to track the date when each step is completed. There would be reporting to compare the actual date of completion vs the project completion date.

Additional request I should give a weightage for each steps in %. and it should auto calculate each steps.

Accepted answers

All comments

Nic Brough -Adaptavist-

What scripting or automation tool are you looking to do this in?

Fabian Lim

Hi @Prabhu Prabhakar

I woud use jira automation to set these fixed dates. You will need extra customfields for each transition such as: "In Progress Due Date", "'Done Due Date" etc.

In the automation rule you basically add the dates with the smart value when the ticket is created as follows: (link: https://support.atlassian.com/jira-software-cloud/docs/smart-values-date-and-time-functions/)

{{now.plusWeek(2)}} -> to add 2 weeks for example

I would use eazybi plugin reporting for this, which captures the history that the transition were pushed.

You can then user additional measures (formulas) to calculate the diferences between completion dates and actual dates. It requires some training to use, but their support staff will guide you if you are stuck.

Regards.

Fabian

Prabhu Prabhakar

Hi @Nic Brough -Adaptavist-

I'm new to scripting but I think I can go for Automation.

We are running with Data Center Edition.

How I can achieve this?

Thanks,

Prabhu

Prabhu Prabhakar

Hi @Fabian Lim

Thanks for the suggestions!

We're running with Data Center edition.

I think Automation is a inbuilt feature with Cloud.

Is there any add-on to achieve this

Prabhu

Nic Brough -Adaptavist-

There is a version of the automation app for DC, that's probably the first thing to try!

Mehmet A _Bloompeak_

Hi @Prabhu Prabhakar ,

It is not possible using the built-in JQL functionalities of Jira. So we developed Status Time app for this exact need. It provides reports on how much time passed in each status. Report can display group of status durations too. For instance total time passed in "Open" + "In Progress" statuses.

Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status entry dates, average/sum reports by any field(eg. average in progress time by project, average cycle time by issue creation month). And all these are available as gadgets on the dashboard too. Here is the online demo link, you can see it in action and try.

If you are looking for a free solution, you can try the limited version Status Time Free. Hope it helps.

Prabhu Prabhakar

HI @Mehmet A _Bloompeak_

Thanks for the suggestion.

Fabian Lim

@Prabhu Prabhakar

Yes you have to purchase automation for jira in the marketplace. Not the lite version as it only contains a few actions.

Regards

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server