sorting the issues according to estimation and due date

Question

Hi,

I need to sort issues according to a calculation of Due Date and estimation. For example- if an issue's estimation is 21 working days (in average that is a month) and an issue's due date is for one month from now- in the sorted list this issue would appear first- it has to start being handles immediately.

On a farther note I wonder if there is a tool or search query that calculated the due date, estimation and assignee - so that for example if the employee X has 2 assigned issues with 21 days estimation- and he has a due date for 2 months from now- his topics would appear first in the search result. Or- an alert can be sent or priority field changed. Is there such tool?

Bill Sheboy · Answer

Hi Sharona,

I was noting Automation for Jira (which is built into the Cloud version).  Please look here to learn about it: https://www.atlassian.com/software/jira/guides/expand-jira/automation

If you can base your calculation on fields in an issue, you probably can write a rule to compute the value with a rule.  It could run automatically when a source field for the calculation changes.

Please talk to your site admin about adding a custom field to store the value.  They may have other ideas how to solve the problem too.

Sharona Keren_n2q6b0 · Answer

Hi Bill,

Thank you for the detailed answer.

I guess I'm trying to do a little bit of both, and the solution above wouldn't do it.

I need to ask something regarding the 4th solution- Is the costume field capable of having a calculation? What would that look like? Will it be updated automatically?

What kind of automation rule did you mean?

Thank you!

Bill Sheboy · Answer

Hi @Sharona Keren

I do not believe there is anything in standard license, out-of-the-box Jira Cloud that can do what you ask.

Some options to try are based upon your need frequency and cost/effort to invest:

* Need infrequently, and little effort: export the data to a spreadsheet and perform the calculation and sort there
* Need a bit more frequently, and some effort: use the Atlassian provided Google Sheets or Excel addin to create/save your spreadsheet from #1 and use it repeatedly
* Need often, and cost is not a factor: investigate the marketplace for JQL addons which can provide calculated fields.  Check the documentation to learn if they do what you require.
* Need often, cannot spend money, willing to do some work: use an automation rule and a custom field to compute your sort field and use built-in advanced search to report your results

For your further note scenario, I cannot tell if you are trying to load-balance team capacity or do some type of critical path analysis.  I recommend trying to solve your sorting issue first and see if your selected solution can also help.

Kind regards,
Bill