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...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi ING_BT ，

What is the calculation logic when you select a date range? If you select the dates from 2020.1.12 to 2020.8.20, do you want to get the number of lapsed consumers in this time period? Does lapsed customer refer to users who purchased between 2019.1.11 and 2020.1.11 but did not purchase between 2020.1.12 and 2020.8.20? Could you please provide more details of the related logic with sample or screenshot? Thank you.

Best Regards

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!