Hi all
In my workbook there is data from Jan-2017 to May 2018.
However, I want to make the prediction and try to include the future months e.g Jun 2018, Jul 2018, Aug 2018 etc.
I tried to use the DATEADD('month',6,[Date]) function to do so. It did create the new date range, but the problem is, the timeframe simply shifted i.e from "Jan-2017 to May-2018" to "Feb-2017 to Jun-2018" instead of adding extra rows in the table like "Jan-2017 to Jun-2018".
Instead of changing the data source, is there any alternative solution to extend the date column in tableau?
The workbook is attached as reference. Many thanks for you guys help!
Hi Pak,
Did you know that Tableau has inbuilt forecasting tools ?
I just set the range to the next 6 months but you get to the forecast by clicking on the Analytics tab, then select forecast and drag it onto the viz to expose the forecast menu. This also exposes the future date range.
HTH 18.1 attached
Peter
