identifying new customers each month

[Anonymous]

Hi Guys,

I'm trying to create a new field in my script where i'm defyining new and old customers.

Let's say we currentlty have 1 current customer in May. A month later a new customer is registered as a new customer.

I would like to create a field that registers new customers per month.

So in July the new customers in juni will automatically turn to CurrentCustomer.

How can I achieve the above?

I have three tables, one with dates fields, another with customerinfo, and last table is fact table. I need to create this field in my fact table.

Please find attached my script.

Regards,

Sam

[Anonymous]

can anyone help me with this?

[sivarajs]

Try the script as

Load

If(Previous(Customer)=Customer,'Old','New') as Flag

Resident tablename order by Customer;

[#4]

You could get which Customers are new through a set analysis formula, but if you want to create a field the the best option is to create a flag as Sivaraj suggested. Enclosed you can find an example

[Anonymous]

Hi Carlos,

Sorry for the late response. I've looked at your script. It's not not correct.

Since Customer A all ready made a purchase in may 2013 he cannot be registerd as a new customer in july.

Same goes for customer B who made a purchase in june, he cannot be registerd as a new customer in july.

What I would like to achieve is that I want to display a list of the current new customers per month. So in July when I get new data, I will have new customers for that month and the customers of the previous month are considerd as old.

note: I need to use both tables to achieve the above. The customer table and the date table.

Hope u can help.

Cheers!

iSam

[Anonymous]

can anyone help me with this issue?

[Anonymous]

I've been trying something new. I think im almost there.

Can some please help?

Attached is a new file.

Current customer A is still counted a new customer, which should not be the case.

Anyone any ideas?

[Anonymous]

I would appreciateany help

[#9]

Sam,

The flag is supposed to help you so that you don't have to create all the possibilities in the script. Enclosed you cand find my earlier example with three listbox objects that I think do what you desire.

Hope it helps.

Ps. Sorry for not replying earlier but in the last weeks I've been very busy.

[#10]

Hi,

Can you explain this script as to what happens.

I've tried using the same but not able to get proper results.

Kindly have a look at the snapshot which covers both the front (table box)

Ex: The "zein" concept though it is OLD it is marked as NEW. Kindly help and the backend script.