Use JQL to fetch the top 15 projects with the highest number of tickets in the past 30 days

Platform Notice: Cloud Only - This article only applies to Atlassian products on the cloud platform.

Summary

Generate a list of the top 15 projects with the highest number of tickets within the last 30 days.

Solution

  1. Utilize the advanced search feature and input the following JQL query: 

    1 created >= -30d order by created DESC
  2. Save this search as a filter using the 'Save As' option.

  3. Proceed to either modify an existing dashboard or create a new one, and then add the 'Issue Statistics' gadget.

  4. In the 'Project or Saved Filter' field, search for the filter you created inStep 2.

  5. Set the 'Statistic Type' as 'Project'.

  6. Specify the 'Number of Results' as 15.

  7. Click 'Save'.

Updated on March 12, 2025

Still need help?

The Atlassian Community is here for you.