New clients filter

[#1]

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

[jyothish8807]

can you please explain your sheet a bit?In the sheet User 1,2,3 are id's of different users? All the first type are same products and so on?

Regards

KC

[#3]

Hello Jyothish Kc you are right.

The User 1,2,3 are ids of different users it is correct.

All the first type are same products and so on,it is correct too.

[jyothish8807 · Accepted solution]

Hi Ivan,

PFA. Please let me know if it fullfill your requirment.

[jagan]

Hi,

Try like this

LOAD

*,

If(Previous(User) <> User  OR Previous(TypeOfContract) <> TypeOfContract, 'New', 'Existing') AS ContractType;

LOAD

DateOfContract,

TypeOfContract,

User

FROM DataSource

ORDER BY User, TypeOfContract, DateOfContract;

Hope this helps you.

Regards,

jagan.

[#6]

Thank you very much, i have one little question. How can i make comparison period longer like 2 years. Now we compare 2012 and 2013 for example, but if i want to compare 2012 and 2014 what should i go?

[jagan]

Hi,

For getting Current Year

Sum({<Year={$(=Max(Year))}>} Sales)

For getting second previous year

Sum({<Year={$(=Max(Year)-2)}>} Sales)

Hope this helps you.

Regards,

Jagan.

[#8]

Thank you