Expand my Community achievements bar.

SOLVED

Exclude user if at least one condition is met in broadlogRcp

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Level 3

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

1289810_pastedImage_0.png

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.

View solution in original post

1 Reply

Avatar

Correct answer by
Level 3

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

1289810_pastedImage_0.png

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.