Dynamic Set Analysis Intersect

[#1]

Hi,

We have a problem with the syntax about Set Analysis "Intersect".

My goal is:

count for every week, the customer that was connected both in the current and previous week.

Thanks in advance to all.

Alessandro

[RedSky001]

I don't know if you can do that in Set Analysis "Intersect".

An alternative is something like this.  For this to work you would need to add all weeks for every customer.

if( above(count(DISTINCT Customer_ID)) > 0, count(DISTINCT Customer_ID))

[#3 · Accepted solution]

Ciao Ale,

I guess you probably want to achieve something like this.

You just have to clone the week field creating a data island.

Basically you don't' need set analysis... despite the performance, something like if(MyWeek = Yourweek, count(distinct Customer)) should give you the numbers...