1 Reply Latest reply on Mar 20, 2016 7:52 PM by Bill Lyons

    Calculated Field Help (Growth Rates)

    Josh Squire

      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

       

      Any ideas?