Show users the top 3 tickets

[Lior Diamant]

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?

[Seon Shakespeare]

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:

• Each of your Priority levels (e.g. "Blocker", "Critical", "High")
• Each of your "Difficulty Levels" (assuming you have a "Difficulty Level" custom field)
• Recently Created (e.g. "created >= -1d" for tickets created in the last day)

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:

1. Create a Jira filter:
   • Use JQL (Jira's search language) to define your sorting logic. For example: project = "XXXX" ORDER BY priority DESC, created DESC, "Difficulty Level" DESC 
     • (This sorts by priority, then creation date, then difficulty level, within the project "XXXX"). Remember to replace "XXXX" with your actual project name/key!
2. Add a "Filter Results" gadget to a dashboard:
   • Configure the gadget to use your filter
   • In the gadget settings, set the "Number of results" to 3

Now your dashboard will show only the top 3 tickets based on your custom sort.

Hope this helps!

[Lior Diamant]

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)"

[Seon Shakespeare]

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

1. Create a Jira filter using this JQL.
2. Add a "Filter Results" gadget to your dashboard and configure it to use your filter.

Remember:

• Replace "XXXX" with your project key.
• You might need to adjust the values for "Difficulty Level" and "priority" to match the options available in your Jira instance.
• Adjust the 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!