1 Reply Latest reply on Aug 1, 2013 1:40 PM by Dan Cory

    Error while attempting Trend Analysis

    Krishnan Sudharsan


      Hello,

       

      I am trying to plot trend lines of population for each Michigan county. I have year as a continuous variable and yet am unable to do so. WHat am I doing wrong? please help.

       

      Thank you.

      Chris

        • 1. Re: Error while attempting Trend Analysis
          Dan Cory

          Please save as TWBX or include the TDE so that we can open your workbook.

           

          However, Tableau 8.0's forecasting feature doesn't work with numeric year fields. It only works with DATE or DATETIME fields. You can use a trendline instead.

           

          If you really want to use forecasting (it won't find any seasonality, though), you need to use a calculation to convert the numeric field back to a datetime. Try DATEADD('year',[year]-2000,#1/1/2000#).

           

          Thanks,

          Dan