Avatar

Correct answer by
Level 4

Hello @Mrityunjay ,

 

If you want to target if one order's total amount > 5000 then you can use like below.

 

1. Start your first query with the order table. First select all the order where ( amount * order quantity) >5000. 

Parvesh_Parmar_0-1654850319830.png

 

2. Then use change dimension activity to switch to recipient. It is important to select single records.

Parvesh_Parmar_1-1654850480711.png

 

3.  Your workflow will be look like below: 

Parvesh_Parmar_2-1654850589827.png

 

 

If you want to target, if total amount of all orders >5000 then you need to use group by. 

For this one you can do like below: 

 

1.  In order query activity select all orders, do not add any condition.

  

Parvesh_Parmar_3-1654850952140.png

 

2.  Add additional data.

Parvesh_Parmar_5-1654851519636.png

 

3.  Disable adding primary key:

Parvesh_Parmar_6-1654851579541.png

 

4. Add condition to select only records where total amount more than 5000.

Parvesh_Parmar_7-1654851675722.png

 

5. After that you would get the customers who total amount is greater than 5000. 

 

6. There is no targeting dimension in the output. If you want to add recipient dimension then use enrichment query: 

 

Parvesh_Parmar_8-1654851845917.png

 it will look like below: 

Parvesh_Parmar_9-1654851889116.png

 

 

Thanks.

Parvesh.

View solution in original post