Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Jan 24, 2020, 10:48 AM

Churn Calculation / divide monthly sum of one measure by first day value of another measure

Hi,

 

I'm trying to calculate the monthly churn ratio based on the customer stock of the first day of the month.

The data is on daily base and looks like that:

Churn Calculation / divide monthly sum of one measure by first day value of another measure

 

I want to have something like the red measure (the green measures I already have):

 

MeasureJan 2019Feb 2019Customer Stock (last day of month)28563453Customer Stock (first day month)14492302Churn (sum of month)140172Churn Ratio (Churn / customer stock of first day of month)140/1449172/2302

 

I tried with

 

Churn Ratio = sum([Churn])/sum([Customer Stock First Day Month])

 

but I only get 0 as result.

I also tried to put a Last()==0 filter on and some table calculations but never got my desired result.

Any help is highly appreciated!

pastedImage_18.png

Churn_Test.twbx
6 answers
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    Jan 24, 2020, 12:38 PM

    AAah I see,

     

    The calculation you have made is perfectly fine .

     

    Just change the format to % or add more decimal places :

    Right click on Churn Ratio <- format :

    AAah I see, The calculation you have made is perfectly fine .

    pastedImage_1.png

     

    Please mark as correct and helpful if this helps.

     

    Thanks,

    Shruten

Write an answer...
0/9000