I have 2 examples in by blog post. One uses shifting, the other adds more rows.
It looks like you started with the method that involves shifting and now trying to make it to add more rows. Here is the excerpt from the relevant portion of the blog post
"But what if you don’t want to trim rows from the beginning of your data? That’s where densification comes to our aid.
The second approach relies on the fact that Tableau can fill in the missing values given a range. What we will do is to shift the last data point to the date we want our forecast to end. This will create a gap between the last value and the previous and Tableau’s “Show Missing Values” option will automatically add rows to fill that gap"
Please use the second approach. That should solve the problem.
I am using auto arima model for forecasting in tableau 9.1 using R script. So i got an error that undefined return type.
So i modify my calculation and set to as.integer. So when that code is run which shows me forecast but it reducing last week number (i set parameter to forecast week number) and forecast it,
So finally i dont get any forecast value.
So please suggest me the solution on that. also i attached .twbx file so you can try and reply me.
In my file only quaantiy and date is available and that date is week wise means my data is week wise so want to forecast week wise.
So please help me to solve this.
Tableau with R.twbx 50.8 KB
This a great work Edwin!
But I have one question.
If I share my tableau dashboard having arima model connected to R with someone who is not aware of Rserve (Tableau and R integration) then is there any way that they don't require to connect to rserve?
Please let me know your thoughts.
I tried replicating this problem on my side. I have done up some tableau workbook using some mock quarterly data but it doesn't seem to be working. I believe the problem lies with the shifted date calculated field ...it seems to miss out 2 months when I keyed in 2 months in the period to forecast field.
Any advise ? thanks.
Forecasting Model Problem.twbx 18.2 KB