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

Issues with Outer Join

edited Mar 14, 2018 10:34PM in Reporting & Analytics for B2C Service 2 comments

Content

I have a report I'm trying to build which shows how long it takes for an agent to respond to each incident.

I'm having a hard time getting all our incidents to show on the report.  Based on the filters I have set, I expect to see several hundred incidents per day, but instead am seeing anywhere from 1-10.  I'm not sure what I'm missing here, but this is not even close.

I've attached the report definition, but here's what I've filtered on:

  • incidents.created - Within the past year
  • incidents.queue_id - All.  This is only included at runtime in case users want to view certain incident queues

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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