New customers in month

[#1]

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)

              , CustomerID

              )

         )

I'm getting strange results, but I feel I'm close...

[lironbaram · Accepted solution]

hei

attach i an example

try it

[#3]

Thanks, it works except for the first month where New Customers should be equal to ALL Customers active in that month, but your formula shows a lot more. But I can live with it...

[lironbaram]

yes and it shows all 7 cutomers who bought in the first month

[#5]

Maybe I must do some tweaking for my particular case, but thank you.