Needed help to pull the top 10 tickets in the each issue type categories in every project

[Vyshnavi S]

have a doubt how to find on what basis the top 10 tickets are considered?

[Adrián García González]

Hi @Vyshnavi S

To get the ‘top 10 tickets’ for each type of issue in each project in Jira, we first need to decide what criteria we will use to define which are the ‘top’ tickets (e.g. priority, votes, comments, etc.). Once we are clear about the criteria, we can build a JQL (Jira Query Language) query that allows us to filter and sort the tickets according to that criteria. Here I explain how to do it step by step:

Step by Step to get the ‘Top 10 Tickets’ of each type of incident

1. Identify the Ranking Criteria

Before creating the queries, we need to define what we will use to rank the tickets as ‘top’. Some common options include:

• Priority: The tickets with the highest priority.
• Votes: The tickets with the most votes from users.
• Number of Comments: The tickets with the most interaction.
• Rank: Order in which they have been sorted in the backlog

2. Building the JQL Query

Let's build a query to get the ‘top 10’ tickets for each type of issue in each project.

JQL Query Example:

Assuming you want to sort by Rank:

project = ‘ProjectName’ AND issuetype = ‘IssueType’ ORDER BY rank DESC

General Query for All Projects and Issue Types

Since you want to get the top 10 for each issue type, you will need to run the query for each issue type present in your projects.

project = ‘ProjectName’ AND issuetype = ‘Bug’ ORDER BY rank DESC

And then, change issuetype for each type of issue you have, like Task, Story, Epic, etc.

3. Example for All Issue Types

Here is an example that you can use for every project and issue type:

project = ‘ProjectName’ AND issuetype = ‘Bug’ ORDER BY rank DESC
project = ‘ProjectName’ AND issuetype = ‘Task’ ORDER BY rank DESC
project = ‘ProjectName’ AND issuetype = ‘Story’ ORDER BY rank DESC
project = ‘ProjectName’ AND issuetype = ‘Epic’ ORDER BY rank DESC

4. Limit to ‘Top 10’ Results

Although Jira does not directly allow you to limit the number of results to display in a query, you can do the following:

• Save Filter: Save each query as a filter.
• Use a Dashboard: Create a dashboard in Jira and add a Filter Results gadget for each filter and in the settings limit the Number of Results to 10. Configure each gadget to show only the first 10 results.

I hope this is helpful, best regards!

[Joe Pitt]

You need to let us know the criteria for 'top 10' before we can begin to answer.