1 Reply Latest reply on Aug 20, 2018 2:17 PM by Patrick A Van Der Hyde

    Churn Rate Calculation

    Suhas Chauhan

      I have a data set which consists of the attribute "is_churn" as  'YES' (means the customer has not renewed ) and 'NO' for customer who would continue the service.

      i would like to calculate the Churn Rate over quarter , but i am unable to figure out any method if this can be possible in Tableau with the given data.

      Any guidance would be appreciated.

      Attached is the link for downloading the dataset.

       

      Formula for Churn rate is = (Customers beginning of month/quarter - Customers end of month/quarter) / Customers beginning of month

       

      Dropbox - Sales_and_Churn_data_final.csv