Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Lost Customers

Hi Team,

1.We have tried to get lost customers data (count and User details)  over any date range it means last some months/years/days. 

Eg: We have data from 01-jan-2020 and we have selected date range - 01-jan-2021 to 20-oct-2021. So we need result like who are did transaction before ( 01-jan-2021) and not done any transaction in between selected date range (01-jan-2021 to 20-oct-2021). 

2. Also we need lost customers data (count and User details) over a previous month/year/day.

Eg: We have data from 01-jan-2020 and we have selected date range - 01-jan-2021 to 20-oct-2021. So we need result like who are did transaction before one month of ( 01-jan-2021) and not done any transaction in between selected date range (01-jan-2021 to 20-oct-2021). 

Thanks for your help in advance.

2 Replies

  • TOK's avatar
    TOK
    Helper II
    3 years ago

    hi Anonymous,

    all you need is max(transactiondate) per customer. You should filter this table with transactions <= max(selecteddate) first, if you really want a timespan.
    Then you can create your measures:

    1. If max(transactiondate) <= min(selecteddate) then 1 else 0
    2. If max(transactiondate) between dateadd(month,-1,min(selecteddate)) and min(Selecteddate) then 1 else 0

    If you could provide an example, I would create a quick tutorial.

    Liked this post? Please subscribe: https://www.youtube.com/channel/UC2lAgCgfyLCHsRv0h-ETBWQ