This content has been marked as final. Show 7 replies
I have some problems with the task I am doing now .
First I have a list of contracts and users and I need to know when the user is new to the system. But i need to know if the user has been new to the system for a selected period.
The deffinition of new user is:
The user that buy a certain type of product for the first time. So if i want to look through the list of new users in 2013 and if the user 1 has bought type first product on 01.01.2013 and then he bought type second product on 12.01.2013, I must indentify him as a new user twice . But if he has bought type first several times during the same year i want to indentify him as a new user only once. I really don't know how to do it.
Thank you in advance,I will be grateful for any help