2 Replies Latest reply on Jun 11, 2018 4:54 AM by Zhouyi Zhang

    Calculating User Churn By Month

    Lewis Cerne

      Hello all,

       

      Consider this sample data source -

       

      User ID
      Month
      Sales
      1Jan100
      2Jan120
      3Jan200
      2Feb110
      3Feb250
      4Feb60

       

      Using this datasource, I am able to visualise new clients every month by using a simple Difference aggregation on the count of User ID, and the cumulative count of clients per month. Here is my question -

       

      As you can see, User with ID 1 has churned out in Jan as it no longer appears beyond Jan. I am trying to plot the churned clients count per month using the provided data source but am failing to do so.  How do I achieve this?

       

      Any suggestion on solving this using Tableau or modifying the data source's design itself (although a charting tool should be easily able to derive this data from the given design) would be most welcome, thanks in advance!

       

      Regards,