Hi,
I am trying to get an understanding of how many customers are new unique monthly was repeat monthly customers.
I actually got pretty far with the help of the answers to this threat: How to flag first-time customers?
But now I am running into an issue I am actually also having with the workbook from the above mentioned thread.
If I want to use count to count the total of True (first time) and False (repeat) I am running into an issue with customer who where first time customer in a particular month but also repeat customers that same month. My "false" count is inflated by double counting customers that should have been only counted as "true".
Any suggestions how to fix it?
Thanks
Carl
Your viz is at the year-month level, so you need to set the calculations to that level as well.
First Order Year-Month per Customer: {FIXED [Customer Name]: MIN(Year([Delivery Date]))*100 + MIN(MONTH([Delivery Date]))}
Is first delivery year-month?:
[First Order Year-Month per Customer] = year([Delivery Date])*100 + month([Delivery Date])
See attached workbook
