I wanted to know if I should create a new table in script containing customer id, product category and first purchase date to calculate new customers product wise, or should I achieve it using set analysis.
@Shweta_Kumari , you should always prefer to do complex logic in script, in that way, your charts are going easy to do.
And for new customers, you need what you said, a new table or new field, calculating if a customer is new, according to your rules of date of purchase and Category
Consider that the definition of new customer can be for date of first purchase, so a customer that bought once but 6 months ago, can be a new customer, or just the customer with a first buy in x months before.
Greetings!! Fabián Quezada (QFabian) did it work for you? give like and mark the solution as accepted.
@Shweta_Kumari , you should always prefer to do complex logic in script, in that way, your charts are going easy to do.
And for new customers, you need what you said, a new table or new field, calculating if a customer is new, according to your rules of date of purchase and Category
Consider that the definition of new customer can be for date of first purchase, so a customer that bought once but 6 months ago, can be a new customer, or just the customer with a first buy in x months before.
Greetings!! Fabián Quezada (QFabian) did it work for you? give like and mark the solution as accepted.
Hi @QFabian , Thank you for your suggestion. I tried implementing what you suggested on script by calculating the first purchase date. I don't know why, but the first purchase date for a few customers is wrong. Thus, I am going through the data and code again. Hoping to resolve it soon.
