This content has been marked as final. Show 4 replies
Using a typical invoices table, I'm trying to calculate new customers in month in a chart with one dimension (Year-Month) and one expression (No of new customers)
In the expression I'm trying to compare min(Date) with min(ALL <CustomerID> Date), but I fail. The closest formula I've got is:
= count( DISTINCT
if( aggr( min(ALL <CustomerID> Date), CustomerID) = aggr( min( Date), CustomerID)
I'm getting strange results, but I feel I'm close...