sorting the issues according to estimation and due date

[Sharona Keren]

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]

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:

1. Need infrequently, and little effort: export the data to a spreadsheet and perform the calculation and sort there
2. 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
3. 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.
4. 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

[Sharona Keren]

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]

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.