Forum Discussion
New v/s Existing customer split
Hi ayushmittal22,
I would approach the problem something like this:
1. Get a virutal table of customers who have sale >0 before the current month.
2. Get another virtual table of the customers who have sale >0 in the current month.
3. Use the EXCEPT() function between both the virtual tables, leaving only the new customers in the current month.
4. Count the rows of the table obtained in the previous step.
5. Divide this number by the total number of unique customers until the last sale date.
Hope this helps.
Thank you,
Vishesh Jain
Hi ayushmittal22,
I would approach the problem something like this:
1. Get a virutal table of customers who have sale >0 before the current month.
2. Get another virtual table of the customers who have sale >0 in the current month.
3. Use the EXCEPT() function between both the virtual tables, leaving only the new customers in the current month.
4. Count the rows of the table obtained in the previous step.
5. Divide this number by the total number of unique customers until the last sale date.
Hope this helps.
Thank you,
Vishesh Jain