Exclude user if at least one condition is met in broadlogRcp

[felixAgung]

Hi There,

I'm trying to filter recipient based on their broadlogRcp.

for example:

1 User have :

- delivery a

- delivery b

- delivery c

How can I say that, if 'delivery b' exist in that user's 'broadlogRcp', excludes that user all together.

so if targeting dimension have:

User a -

- delivery a

- delivery b

- delivery c

User b -

- delivery a

- delivery c

The filter will return with JUST 'User b'. Any help would be appreciated.

Regards,

Felix

[_nkur · Accepted solution]

Hi Felix,

You can do it either of 2 ways

1. Using Recipient as Filtering Dimension and using 'Don't exists such as' query on broadlogRcp. Below screenshot

2.Starting BroadlogRcp as filtering dimension and than changing dimension back to recipient.

I prefer option 2 as option 1 is sub query execution and sub queries are know for there performance hit.

Let me know if you need more details on any of these options.

Regards,

Ankur A.