New customer analysis using set analysis

[rwunderlich]

I'm working on the classic new/lost customer problem using set analysis. I've found a few examples on the forum, but they don't seem to fit exactly what I'm after. I'm using the AsOf table approach with a "MonthsBack" field. Attached is a simple example of where I'm getting stuck.

I expected that the set

{ <MonthsBack={'0'}> - <MonthsBack={'>0<4'}>}

would give me Customers who ordered in the current month and did not order in the prior three months. It's not working. Any idea where I'm going wrong?

Thanks,

Rob

[llauses243]

Hi,

This post is very singular, is refered to customers, is refered to set analysis, with partipation of 3 big referents.

Thanks Rob, John y Oleg.

[ecolomer]

Yes is very very singular and very useful

Thank's for sharing

Saludos

EC

[Anonymous]

Yes, this is a great post, quite surprised there aren't many more New Customer analysis threads. This works well but takes an unsurprisingly long amount of time and consumes a large amount of resources when trying to calculate from a dataset with circa 10 million records over 15 months, and I will be required to expand this data set. Is this the most efficient way of doing this?

[jaymeknapp]

How do I set/get the 'MonthsBack' and 'AsOfYearMonth' ?