4 Replies Latest reply: Oct 5, 2011 9:13 AM by Lucian Cotea

# New customers in month

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...

• ###### Re: New customers in month

hei

attach i an example

try it

• ###### New customers in month

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...

• ###### New customers in month

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

• ###### New customers in month

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