Grouping fields together for reports

[jcmings]

My client is requesting the ability to group together certain values (fields on a table) to display different types of reports. For example, there is a desire to group together Assignment Group A and Assignment Group B on the x-axis and display something like Status along the y-axis. This is different than using the Stack by config for reports. Is this possible?

Here is another use case: I want to group together "Closed Incomplete" and "Closed Complete" cases, and separately, I want to group together "Work in Progress" and "Ready" cases to distinguish between Closed/Open cases. I could display all four along the x-axis, but I would rather group them together. Is this possible?

Note: I do not currently have Document Intelligence installed; I don't know if the "Field Groups" capability addresses my issue, and if it does, I do not have the ability to use Document Intelligence.

[Slava Savitsky]

To distinguish open and closed cases, simply group by Active rather than by State.

[jcmings]

That was just an example, maybe a poor one, but your comment doesn't address the issue at-large. 

[Slava Savitsky]

There are two pieces of functionality in ServiceNow that address this issue at large: bucket groups in Performance Analytics and report ranges in standard reporting.