Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Dashboard gadget to show projects in single category

How can I create a view that shows all projects under a specific category (not the issues, just the projects), or all projects that I am the lead on?

2 answers

1 accepted

0 votes
Answer accepted

You can't really, everything is focussed on the issues.

I can get you close though.  Create a filter for "issue in category <x>", and save it.  Then go to a dashboard (create one if you want), and add a new "filter statistics" gadget to it.

Give it the filter you chose and choose "project" in the statistics field.

You'll get a list of projects in that category, and the number of issues in each (as long as they have at least one issue)

I tried that, what you have in quotes is not the exact syntax (I'm brand new to this)? For this let's say I have a project category labeled SUPPORT (and I currently have 2 projects marked with that category).

Ah, sorry, I was thinking in code, which doesn't translate to JQL directly.  Try filters like "Category = Support"

The other bit I forgot - in the gadget, check the "include resolved issues" if you want to see a count of all the issues, rather than just "open"

I actually tried that, but instead of listing the projects one time it seems to be listing the project for each issue, so for example I see "Fake project #1" 3 times (I'm guessing because there are 3 issues tied to it).

That's not what the filter statistic gadget does.  Could you show us the configuration for it?

Apologies for not responding sooner. I had the wrong gadget. I got it working per your suggestion. Thanks

0 votes
Mikael Sandberg Community Leader Oct 24, 2018

For projects in a specific category you can use the Projects gadget, it allows you to select categories. To get the projects you are the lead for, create a query using project in projectsLeadByUser() and then you could use the Heat Map gadget and set the Statistics Type to project.

I tried that, but it's listing projects multiple times (like it's listing the project name for each issue in the project).

Mikael Sandberg Community Leader Oct 25, 2018

Is the Projects gadget listing the projects multiple time or the Heat Map?

Mikael Sandberg Community Leader Oct 25, 2018

Hmm, odd. The Projects gadget should only show the project once, no matter how many issues there are in it. I use it on Server with projects that have thousands of issues and the projects only show up once. I just checked on Cloud, same thing there, as you can see from this screenshot


Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you