0 Replies Latest reply on Jul 5, 2018 1:34 PM by Akshaya Jagan

    Unable to count new buyers and churned buyers

    Akshaya Jagan

      Hi All,

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

      Thanks!