Need to get the results which are not purchased in the last 18 months

[Sathyam_Chandan]

Dear Community leaders,

I have recipient schema and purchase history schema which are linked.

I need to get the recipients which were not  do any purchases in the last 18 months. 

can you please tell me at the filter wizard in the filtering condition.

Regards

Satya

[ParthaSarathy · Accepted solution]

Hi @Sathyam_Chandan ,

Hope recipient and purchase history schema is 1-N link.

In your query, have targeting and filtering dimension as recipients,

Filtering condition:

Expression > scroll down and you can see purchase history schema and select it.

purchase_history do not exist such as

creation date on or after MonthsAgo(18)

Filtering Condition will look like below,

[Sathyam_Chandan]

Thank you @ParthaSarathy 

it is showing correct results.

Regards

Satya