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)
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"
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.
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
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