How can we fetch No transations made by customer in last 6months

[Shrutii]

@Parvesh_Parmar ,@AkshayAnand 

,@isahore ,@AndreaBriceno,@ParthaSarathy

,@ParthaS ,@Craig_Thonis ,@Manoj_Kumar_ ,@Amine_Abedour ,@Marcel_Szimonisz,@DavidKangni 

,@Amit_Kumar,@ShashankNigam02,@Ganesh5067, @Jonathon_wodnicki

@Denis_Bozonnet 

Hi All,

I m really stuck in on challenging situation

where I need to  fetch customers who had made no transaction  in last 6months and target them

reference:

customer details are in Customer table

and transaction details are in transaction  table

transaction  table and Customer table  are linked

please help

its really imp

[ParthaSarathy]

Hi @Shrutii ,

Select targeting and filtering dimension as customer table, 

Query condition:

transaction table DO NOT EXIST SUCH AS

DateOnly(@transaction_Date) Greater than or equal to MonthsAgo(6)

The query condition will look similar to below image,