Reporting M-N Metrics by Other Tags
The following procedure is applicable to XAE versions 1 and 2. It is advised to upgrade XAE to version 3 for improved handlng of M:N. See Many-to-Many in Logical Data Models for more details.
This article builds on what you learn from Reporting M-N Metrics by Tag - you created a report showing the number of tickets filtered by a specific attribute value (Ticket Tag=customer). This article shows you how to extend that report to show all of the other tags that are associated with the filtered tickets.
Steps:
- Create a new empty report.
- Add the numeric filter for # Tickets w/Customer:
- Add the # Tickets metric to the What pane of the report. The report now shows simply the number of tickets with Ticket Tag=customer.
- To the How pane, slice the report by the Ticket Tag attribute.
- The report now displays the count of all tickets that contain the customer tag, broken down by the other tags that are present in the ticket. Your report should look like the following:
- Sorting the report in descending order by the count shows customer issues that may have significantly wider impact or correlation with other types of issues.