Hi everyone,
I'm looking for a way to sort the tickets in my project based on a custom formula that takes into account several custom fields, like priority, creation date, difficulty level, etc. Is it possible to set up a board so that when a user views it, they only see the top 3 tickets after this sorting is applied?
Hey @Lior Diamant
Welcome to the community!
One way to filter your view in a Jira board is by using Quick Filters to highlight your most important tickets.
For example, you could add quick filters for:
Users can then select these filters to see tickets based on those criteria.
If you want a more precise way to display the top 3 tickets based on a custom formula, you can use a Jira dashboard:
Now your dashboard will show only the top 3 tickets based on your custom sort.
Hope this helps!
Thanks for the quick response, Seon!
That does help. Is there a way to create a more advance formula for sorting? say "ticket_age_in_hours + (difficulty_level * 3) + (priority_level * 4)"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Lior Diamant,
You should be able to achieve this using a Jira filter and a dashboard gadget!
Here's an example JQL query you can use:
project = "XXXX" AND created >= -1d AND "Difficulty Level" = 3 AND priority = "Level 4" ORDER BY priority DESC, created DESC, "Difficulty Level" DESC
Remember:
created
clause if needed.For more details on using JQL (Jira's search language), check out this helpful documentation:
https://support.atlassian.com/jira-software-cloud/docs/what-is-advanced-search-in-jira-cloud/
If my answers have helped feel free to mark my comment as the accepted solution, so others can find it easily. Cheers!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.