Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
The below expression should result the counting new customers who appeared over last 7 days.
can you help please to find why the below expression does not work:
count({$<[Customer Name]
={"=min({$<Turnover={'>0'},[Offer Creation Date]={'<=$(=max([Offer Creation Date]))'}>}[Offer Creation Date])>=$(=max([Offer Creation Date])-7)"}>}
distinct [Customer Name])
Thanks
Jacek
Hi ,
I did not understand first part of section access but I tried with the date range, please try
count(distinct({$<[Customer Name]={"=min({$<Turnover={'>0'},
[Offer Creation Date]={">=$(=Date(max([Offer Creation Date])-7))<=$(=Date(max([Offer Creation Date])))"}>} [Customer Name]))
Thanks
Thanks, the expression is still not working. It should count only customers who made turnover in last 7 days for the first time ever.