How can I rank issues based on mathematical formula?

Question

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:

* Effort (1-5)
* Value (1-5)
* Financial Cost (1-5)

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?

Vincent Mutambuki { Mumo Systems } · Answer

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.

Alex Chan_nw6sbe · Answer

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!

Shawn Masters · Answer

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