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

Counting incident responses: incidents.last_resp vs stats.resp_incidents

Accepted answer
edited Oct 15, 2015 3:12AM in Reporting & Analytics for B2C Service 4 comments



According to two different out-of the-box reports, I am getting significantly different information about the number of incident responses over a date range.  Why?

The first report is under Service\Incident Reports\Incident Trend\Responses.  It uses incidents.last_resp and reports 268 responses.

The second report is under Service\Incident Reports\Incident Trend\Incident Trend.  It uses stats.resp_incidents and reports that there were 143 responses.

Considering the Responses report is limited to just one response per incident and that, presumably, the Incident Trend would count multiple responses per incident during a range, I would have expected the second report to have the higher number of responses.  Can anyone explain the discrepancy and the relative merits of each report?

Howdy, Stranger!

Log In

To view full details, sign in.


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