am a beginner in tableau.
I have this in my data
month | Churn2012 | 12012 | 02012 | 12012 |0
I want to calculate the percentage of churn like this
month | Chunr
2012 | 50%
hence what i did was to create a calculated field churn_yes
(if [Churn]=1 then
my churn_total looks like this
so i have this now
month | Churn_yes | churn_total
2012 | 2 | 4
I then tried to do
but it says cannot mix aggregate and non agregate values. any help?
Please find my approach as referenced below and stored in the attached workbook.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...