How do I get a count of all sub-items in a structure by status category?

[Matthew Mallard]

I have a a multi-level structure that shows a bunch of levels. I am trying to figure out a formula that will count the number of issues under a level that are in a specific status category. This would allow a individual to understand how far a long a top-level issue is by seeing a count of how many issues under it are Done, In Progress, or To Do.

[Lee Correll · Accepted solution]

There is a gadget that will show you at least part of that information. Add the Greenhopper Project Progress widget to your JIRA dashboard and you'll get a visual (red/yellow/green) indicator on % in each status (as you defined the statuses).