I tried using Tableau's table calculations for growth rates, but nothing is giving me the results I need and I'm stuck trying to create a calculated field that works.
I am pulling our membership (customer) count as of each month end for the last 36 months. I want to calculate the annualized YTD growth rate for each month so I would need a formula that would operate as below:
(Countx - County (Where Month (Effdatey) = 12 AND Year(Effdatey) = Year(Effdatex)-1) / County / Datediff(Effdatex,Effdatey) * 365 = Growth Rate
Difficult to answer without seeing your data and view. Can you attach a sample packaged workbook (.twbx)? If you have confidential data, please see Anonymize your Tableau Package Data for Sharing |Tableau Support Community