7 Replies Latest reply: Sep 23, 2014 3:20 AM by Ivan Kantemirov RSS

    New clients filter

    Ivan Kantemirov

      Dear collegues.

      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