Show users the top 3 tickets

Question

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 · Answer

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 * Create a Jira filter using this JQL. * 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!

Lior Diamant · Answer

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 · Answer

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:

* 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!

* 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!