You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Agent assigned incidents report displaying all agents (even with 0 assigned incidents)

edited Sep 21, 2017 3:19PM in Reporting & Analytics for B2C Service 5 comments

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!