Forum Discussion
Calculation New, Repeat Customer
Hi,
Prepare a simple Table visual as seen in the screenshot below. See which Customer codes are not being identifies correctly. DIY.
Hi Ashish_Mathur,
I have followed your advise then found the result after choose a few customer to mapping with manual.
1. New --- customer code: CT01718 have one transcation in Oct'23 but your calculation is showing in "Repeat". It should be in "New"
2. Repeat --- customer code: CT03498 have 02 transcation in Oct'23, your calculation is showing "Repeat", it should be in "New" because transcation are in the same month.
=> Even customer have one order or many in the same month, we still call "New" if they didn't have order in the last month.
=> For customer have order in the last month, and current month are also have then called " Repeat".
=> column that we count are InvoiceType "F2" and OrderType "SALE". these column are refer to order and sales, beside it's return.
Sample file https://drive.google.com/drive/folders/1UzgG-CXW3G0diCSfILUYRqXq9piZWZLj?usp=sharing
Any suggestion?
Hi,
CT01718 has transactions in Aug and Sep as well.
The same if true for CT03498 as well.
Please recheck.
Hi Ashish_Mathur,
Yes, however we're comparing current and last month to find how many new and repeat of customer in the current that we stand.
So all questions that raised in Oct and compare to Sep. If we're standing in Sep then compare to Aug.
Please kindly check and advise.
Thanks and Regards,
In the month filter drop down, select only one month - October. Both those codes have transactions in September and therefore for the month of October, they should both be classified as Repeat.
Hi Ashish_Mathur,
One customer have multiple sales team serviced (sell different brand/category), if you check this customer code: CT01718 will see transcation from Aug till Oct. But we filter by sales team = Food1, Brand = Kingfisher then have transcation in Aug & Oct.
So if we're standing in Oct, then this customer is New because no transcation in Sep.
Please check and advise.
Hi,
Please check now. File attached.
Hi Ashish_Mathur,
I have checked your file, the number is more than I count manually in excel.
This result is distinct count in excel file.
Please check and advise.
How do you expect me to help you with just that statement. DIY. Solve it by yourself now.
Hi Ashish_Mathur,
Just feedback what I see however still need your support and advise. sometimes we misunderstand or wrong explain then result also are different.
Thanks and Regards,
I really do not know how ealse to help you. Create a small dataset and try my formulas on that small dataset. See if you get the perfect result there or not. If there is a problem even on that small dataset, then we will revise the formula. Finally we will then plug in your large dataset. Please send time on doing this checking yourself.