How can I get a count of issues per project for all project in Cloud like I can in Server?

Rob Horan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 1, 2020

In server you can go to the Administration section, select Projects, and get an issue count per project.  Specifically an at-a-glance view of the number of issues in each project in a list form, as provided in Server.  The issue count is missing in Cloud, it seems.

Querying each project individually is not really the best option.  In addition to requiring much more manual work (we're not talking 2 or 3 projects) theres also the question of whether or not the results can be trusted, if browse permissions are not set, or if there is issue-level security in use.

5 answers

1 accepted

8 votes
Answer accepted
Sramanth Pandeti
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 1, 2020

Hi @Rob Horan You can create a JQL filter which has issues from all the projects and save it. Navigate to your dashboard and select the "Issue Statistics" gadget. Find your saved filter and select "Project" as a statistic type and save it. This should give you the issue count for all the projects.

Screen Shot 2020-09-01 at 9.34.46 AM.png

Rob Horan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 1, 2020

Hi - thanks - I see I need to add a little detail for clarity.  I'm not looking for a total for the site.  I need a total for each project in one place; an at-a-glace view of the total number of issues in each project.

Sramanth Pandeti
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 1, 2020

@Rob Horan I guess I should edit my above comment to say "Issue count for each project". :)  The issue statistics gadget with project as statistic type should show you the total for each project if you have the filter with all or some projects listed in it. (screenshot below). 

Screen Shot 2020-09-01 at 10.14.15 AM.png

 

Let me know if this is what you're looking for.

Like # people like this
Rob Horan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 1, 2020

This is helpful, but since it relies on filter results, this only works in cases where my user has the ability to see issues in those projects. 

Like Abhi Singh likes this
Abhi Singh November 7, 2022

Wonderful solution!

Rob Horan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 7, 2022

@Abhi Singh  - bear in mind if you do not have browse rights or there is issue security involved you will not get the right info

Kristen Bond December 16, 2022

i can only return 50 results at a time.  What if there are more than 50 projects?

Like Gabriel Muller likes this
Filipe Dias September 28, 2023

Hello

I don't think this works.

I tried, to get the number of issues in one project only, and for that I created a filter that's only this: "Project=NAR" then applied it to the statistics and notice that the result doesn't make any sense. So I clicked on the number of the results, it leads to the filter and for my surprise the filter is now "Project = NAR AND statusCategory != done" which doesn't make any sense. I want to know all the issues, not only the != Done ones.

 

Total.png

 

My bad. Just found the option to return all the issues

 

ShowALL.png

Total_2.png

4 votes
Derek White March 31, 2022

On Server you can go to the Projects Admin page and see it all, as an Admin without having permissions to the issues.

This can't be done on cloud. The count is not shown - missing feature. The API can return it as part of the experimental "insights" object - which is simply unfortunately named since they also now own Insight (the asset management app).

Why can't an org admin, site admin, or jira admin have simple access to basic info? Why is it so hard for Atlassian to understand our needs and provide solutions? And, why would you remove a feature as basic as "how many issues are in a project" from Cloud? Makes no sense.

1 vote
Rick Westbrock April 14, 2022

I just tried Sramanth's solution in Jira Cloud and the gadget is only showing me 452 issues even though the filter returns over 1000 issues. I had to set Show Resolved Issue Statistics = Yes to get the proper count of 10,143 to be displayed.

 

This workaround definitely works but as someone else said it is shameful that the Jira Cloud UI (even for administrators) doesn't show this information.

April August 22, 2022

"Shameful" is a great way to put it!

Just spent the last 30 minutes adding myself to all the perm schemes in yet another instance, just to get some basic statistics.

Kills me to think that somebody had to go find and kill this existing code in order to improve cripple the admin interface, and now we get to pay extra for this total waste of time.

Like # people like this
0 votes
Lori Holly
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 11, 2024

Found this ticket in Atlassian's backlog if you want to vote on it (for all the good that seems to do...) 

https://jira.atlassian.com/browse/JRACLOUD-81710

 

0 votes
A.J. Apple May 11, 2023

Can I get an issue count based on a JQL filter that shows me how many issues there have been over time by day?

Rick Westbrock July 11, 2024

That sounds like something you would need Atlassian Analytics for as filter results will only ever show issues at the point in time the filter is viewed (as far as I know).

Suggest an answer

Log in or Sign up to answer