Is the Single Level Group By Report only for Company-Managed Projects?

[John Tucci]

I would like to create Single Level Group By reports for my team-managed projects, but that option does not appear when I select Reports for my projects. 

If Single Level Group By reports are not available, is there a way to include Issue Status in a filter. We have filters that group a developer's issues across multiple projects, but Issue Status is not included.

As always, my continued "Thanks" to this awesome Community.

-John M. Tucci

 Megabyte Systems, Inc.

[Trudy Claspill · Accepted solution]

Hello @John Tucci 

The Single Level Group By report is not currently available in Team Managed projects.

Can you show us an example of the filter you want to modify?

If you are using ORDER BY Assignee to order the results by Assignee (psuedo-grouping), you could use ORDER BY Status to group them by issue status. If you want to order the results by Assignee, and then by issue status for each Assignee you would use ORDER BY Assignee ASC, Status ASC

[John Tucci]

Hello @Trudy Claspill :

   Thanks for the prompt and informative reply. Below is an example of the filter and its output. In the summary list in the left column, I would like the issue workflow status to appear so that I don't have to open each issue to see Status.

[Trudy Claspill]

Hello John,

Unfortunately what appears in that summary panel is not customizable.

You could change the view from Details to List, and then set the Columns to the fields you want to display.

If you save the filter after setting the Columns then each time you open that filter it will remember the Columns settings.

[John Tucci]

Hi, Trudy:

Thanks, again, for the helpful info. Your above suggestion will work very well for what I want to achieve!

I always appreciate your prompt, helpful, and educational replies.

Kind Regards,

-John

[Trudy Claspill]

Hi John,

You're welcome.

If your question has been adequately addressed, please consider marking the Answer as Accepted to help other users find posts with validated solutions.

[Hannes Obweger - JXL for Jira]

Hi @John Tucci

I'm glad you found a solution that works for you! Just to put this out there, if you're open to solutions from the Atlassian Marketplace, you could easily group your issues by any field - or any fields, if you want to do nested grouping - using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including the support for issue grouping by any issue field(s), and many others.

This is how this looks in action:

As you can see above, the resulting view remains fully interactive - meaning that you can keep working on your issues directly in JXL. You can also easily calculate sum-ups across your issue groups, e.g. to get status distributions for your groups of issues. 

Any questions just let me know,

Best,