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

Number of Incidents with Responses

edited Oct 2, 2017 1:28PM in Reporting & Analytics for B2C Service 1 comment

Content

I've been reporting on response time and incidents with responses (response being when the initial response email is sent).  We have changed our reporting methodology slightly to include a field capturing responded by phone.  The field time stamps when another field is chosen as a yes.  The below expression is what I currently use to count how many incidents had responses and am looking to change it to:

Count if inc_performance.intv_type=1 or if dt_phone_response is not null(blank)

current: count(if(inc_performance.intv_type=1,'Y'))

Can anyone assist in this?  Thanks! Vanessa

Code Snippet

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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