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

Outer join not pulling through all incidents - just where they have a relationship to an incident

edited Oct 19, 2017 4:06PM in Reporting & Analytics for B2C Service 3 comments

Content

Hi,

So:

  • Added a incident reference
  • Added transaction type
  • Added transaction id3
  • Did outer join
  • Filtered transactions on type =**** and id3 in A,B,C

The resulting report only shows where an incident matches with the relevant transaction but I also want to show incidents where a transaction doesn't exist for these filters (null). How would I go about this?

So:

  • Show all incidents (with incident filters applied) whether or not the transactions (filtered) exist

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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