Agent assigned incidents report displaying all agents (even with 0 assigned incidents)
Content
I'm attempting to create a report that displays a count of number of incidents that have been assigned to each agent over a specified amount of time. What I can't figure out is how to display all agents even if they have 0 incidents assigned over the specified date range. My report only displays agents that have 1 or more incidents assigned to them.
I attempted to outer (and inner) join several combinations of the accounts, transactions, and incidents tables and cannot get the desired results. Any ideas?
Tagged:
1