Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there
I am struggling to figure out how to count the number of customers that purchased more than 3 times in the past 12 months. The result given by the expression below is empty.
COUNT({<
[Customer ID] = {"=sum({<
[Type]={'P'}, Date={">=$(=date(addmonths(Max(Date),-12),'YYYY-MM-DD'))<=$(=date(Max(Date),'YYYY-MM-DD'))"}
[Total Events])>=3"}
>}distinct [Customer ID])
Please help