How can I rank issues based on mathematical formula?

I would like to create a board which is automatically ranked based on fields assigned to the ticket.

I have three fields, each of them a 1 - 5 value:

I would like to calculate the SUM of these three fields for each ticket, and then be able to rank by this SUM on a board.

This is obviously a a fundamental function in a spreadsheet - is it possible in JIRA?

2 answers

1 vote

We use Abacus for Jira Cloud in our instance - being on server you have more options but by default Jira doesnt do calculations.

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

Thanks Shawn - do you have any recommendations for free apps (since we are doing just a SUM and write to a field)?

Really appreciate your insight!

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

0 votes

Abacus can calculate values from a select field. Using the Generic Numeric formula type, you can simply add the select fields

Effort (1-5) + Value (1-5) + Financial Cost (1-5) = Result Field.

Then the execution plan will triggered every time issue is updated or scheduled to run a specific time.

To be fancy you can even map text to numbers and Abacus will calculate.

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