I need some guidance on good data reporting where users are a part of multiple organizations.
Our work flow is as follows:
- End User is a part of two organizations, Org A and Org B
- Ticket is opened under Org A, but we manually change the organization in the ticket to Org B
Next, I run a report where:
- What = # of tickets created
- How = Organization Name
The result of this report is that the # of tickets created is logged under Org A, and not Org B. The report shows no tickets created for Org B.
How do I run a report that shows the number of tickets for Org B?