So , I am trying to find number of sales [in my case its the countd(order_id)] .
I want to find if less than 10% of customer sales came within last 20 % of its Existence then that customer is inactive .
4 Antworten
Hello , so I am attaching a lookalike data file in excel format , but my original data has huge number of rows .
Basically here new_min_date is the last 20% of date of max_date in date format. I got that by using above formula I mentioned . In that 20_existence is INT(exsistence)*0.2
