I want to forecast a time series and see how accurate the prediction model is. The forecast SPL is:
| timechart span=1d sum(VOLUME) | predict "sum(VOLUME)" as prediction algorithm="LLP5" future_timespan="365" holdback="0" period=365 lower"95"=lower"95" upper"95"=upper"95" | forecastviz(365, 0, "sum(VOLUME)", 95)
Is there a way I can tell the algorithm to use only data from up to 6 months ago, forecast the next 6 months, and then overlay the real timechart from the past 6 months? Also if it could include the r squared and RMSE that would be fantastic.
