Skip to main content
Level 4
Apr 10, 2024 4:42 AM UTC
Question

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

@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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

ParthaSarathy
Community Advisor
Community Advisor
Apr 10, 2024 7:07 AM UTC

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,

Translate
~  ParthaSarathy S