Auto calculate date between statuses

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.

3 answers

0 votes

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.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

HI @Mehmet A _Bloompeak_

Thanks for the suggestion.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • Mehmet A _Bloompeak_ likes this

0 votes

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