Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I'm having trouble counting new customers. The chart script only shows data for the current month. Formula: "Number of new customers" below:
=count({<Year=, Month=, [CustomerID]= E({<MonthField={"$(=max(MonthField)-1)"}>}), MonthField={"$(=max(MonthField))"} >}distinct [CustomerID])
I would like the table to be updated with each selection of the month / year range.
Please help.
PapaJapa
Try the Above function. If Count(Distinct [CustomerID]) is the number of customers, then Count(Distinct [CustomerID]) - Above(Count(Distinct [CustomerID])) should be the new customers.
May be this
Sum(Aggr(
If([CustomerID] <> Above([CustomerID]), 1, 0)
, [CustomerID], YearField, MonthField))