1 Reply Latest reply on Oct 18, 2018 9:09 PM by Shinichiro Murakami

    % Churn by age does not work

    Alexander Farr

      Hello everybody,

       

      I want to display the percentage of customers that have indicated that they want to churn (Churn=1, 0 otherwise) the contract compared to all customers of their age group. I have used following formula:

       

      Count(Churn=1)/Size()

       

      However, this yields following:

      1.png

       

      Why is my formula wrong?

       

      In the same (attached) workbook I have created following visualization:

       

      2.png

      How can I add a label for the null values?

       

      I really appreciate your help.

      Thank you!