Create a matrix report
In this video, you will learn:
- When a matrix report can be useful
- And how to create a matrix report
Activity: Create a matrix report
Create a matrix report that shows how many requests there are in each status, sorted by request queue. This gives you a quick snapshot of the amount of work coming in and how well you’re keeping up with it.
You want the request queues to appear on the row groupings. Status appears as the column groupings. Name your report “Requests by Status and Request Queue.”
Answer
-
Select Reports from the Main Menu.
-
Click the New Report option and select Issue.
-
Go to the Groupings tab and click Switch to Matrix Grouping.
-
For Row Groupings, select Project > Name.
-
For Column Grouping, select Issue > Status.
-
Go to the Filters tab.
-
To make sure you see only requests in active request queues, add the following filter rules:
- Project > Status Equates With > Equal > Current
- Queue Definition > Is Public > Not Equal > None (this is how we know a project is actually a request queue, by the Queue Definition being assigned to one of the public options.)
-
Click on Save + Close. When prompted for a report name, type in “Requests by Status and Request Queue.”