I am relatively new to tableau and am having difficulty in calculating new buyers and churned buyers count.
When a buyer makes revenue in Jan and doesn't make any revenue in Feb, he is considered churned for Feb
Likewise, When a buyer's revenue is zero/null in Jan and greater than zero(some revenue) in Feb, he is considered as a new buyer for Feb.
When a buyer makes his first revenue in Jan, zero in Feb and some revenue in March, he is considered churned for Feb and new buyer for March.
I am trying to get it in a table format like below( ignore the numbers, they are incorrect)
I used lookup to count new buyers but I'm having difficulty in doing the Sum of AGG. Min date didn't work either as i some cases, paused and renewed buyers are also counted as new buyers.
I have attached the workbook and sample data. Please help!!