Can Jira Agile rank be based off of a calculated field?

I am starting to build up an Agile project, and have current tickets that are prioritized (using a SQL script) based off of field calculations. 

As an example, revenue implications and goals implications are weighted to determine the ranking of the ticket:  (Revenue*8)+(Goals*10)=Rank.

Can Agile base the rank off of a calculated field like this, or does it only support ranking by dragging and dropping?




2 answers

1 vote

No, the way ranking works is that it needs a single unique number to indicate an issue's position in the list.  Your formula is fine for prioritisation, but cannot be used for ranking because you could end up with duplicates.

Thanks Nic.  Is there a way to view tickets in a certain Agile Stage (such as To Do) in order by a prioritisation number?  Even if it's not on an Agile screen?  Or another way to ask this question is can you view JIRA tickets filtered by Agile stage and ordered by a field (or more) on the ticket?


Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,331 views 14 20
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot