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

help: Filtering contacts from report who have ANY incidents of a particular type

edited Oct 6, 2016 3:39PM in Reporting & Analytics for B2C Service 2 comments

Content

Hi everyone,

I'm sure there's a simple solution for this but I'm really struggling to find a way to filter a report the way I want to.

My basic structure is this: I have several contacts in my database (let's call them 1, 2, and 3), and each contact may have several incidents (or none at all). Each of the incidents has an 'incident type' - let's call the types A and B. Let's say contact 1 has three incidents, types A, A, and B, contact 2 has 1 incident, of type A, and contact 3 has no incidents.

What I'd like the report to do is show me all contacts, but filter out any contact that has any incidents of type B out of the report. The problem I'm having is that the report adds a row for each contact per instance of an incident. So at the moment, my unfiltered report is:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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