Forum Discussion

ING_BT's avatar
ING_BT
Icon for Helper I rankHelper I
5 years ago
Solved

Calculating lapsed consumers - table with no transaction info

Hello everyone!  I am well aware that some posts already exist on this topic, however, I am having issues adapating the solutions to my situation:    The definition of a lapsed consumer: # of co...
ING_BT's avatar
ING_BT
Icon for Helper I rankHelper I
5 years ago

Hi Anonymous 

 

The logic of the date range would be just to use the first selected date as a marker! So in your example from 2020.1.12 to 2020.8.20 we would consider 2020.1.12 as being the date from which our calculation would be based on (so the selected value) 

If that makes sens ? 🙂 

  • ING_BT's avatar
    ING_BT
    Icon for Helper I rankHelper I
    5 years ago

    Hi Anonymous ! 

    Thank you very much for your help 😁

     

    Have a good day,

    Bt

  • ING_BT's avatar
    ING_BT
    Icon for Helper I rankHelper I
    5 years ago

    Do you know why it doesn't work anymore when a relationship is created between the date table and the date column of the customer table ?

    Thank you!