I am trying to write a formula based on new customer registrants joined to sales history that would give me a unique count of customers [CustKey] that has made a purchase. I would like to be able to make a simple graph of these customer by date establish month that would show # of unique customers register [New Customers], # of unique customer who purchased and what percent activated which would be purchasers / total number of customers registered.
I have attached a sample package if that would assist.
Any help would be greatly appreciated as all of the formulas I have tried returns total number of customers but not the number of customers who have purchased.
I encounter this problem often when trying to get a similar distinct customer count who purchased by timeframe. Using your workbook, I made the following formula.
COUNTD( if [NetSales] > 0 then str([CustKey])
else 'x' end) -1