Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Filtering Dimension - Segmentation

pavlinao8032150
Level 2
Level 2

Hello,

is there any difference in the following two approaches when creating segmentation that should show the last 3 transactions for each recipient:

1) Targeting dimension: Recipients

     Filtering dimension: Recipients

     Add data...Data linked to the filtering dimention

or

2) Targeting dimension: Recipients

     Filtering dimension: History of transactions

     Add data...Data of the filtering dimention

Regards,

Pavlina

1 Accepted Solution
Vapsy
Correct answer by
Employee
Employee

Hi Pavlina,

Both approaches are correct.

Major difference will be the type of SQL query generated in background.

Option two will generate a JOIN query which is far more effective when it comes to working on huge volumes.

Hope this helps. If you find the answer to be correct, please mark it as the correct answer so that others can benefit out of it.

Regards,

Vipul Raghav

View solution in original post

1 Reply
Vapsy
Correct answer by
Employee
Employee

Hi Pavlina,

Both approaches are correct.

Major difference will be the type of SQL query generated in background.

Option two will generate a JOIN query which is far more effective when it comes to working on huge volumes.

Hope this helps. If you find the answer to be correct, please mark it as the correct answer so that others can benefit out of it.

Regards,

Vipul Raghav

View solution in original post