Exclude user if at least one condition is met in broadlogRcp

felixAgung

31-08-2017

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

Accepted Solutions (1)

Accepted Solutions (1)

_nkur

31-08-2017

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.

Answers (0)