we would like to implement a line chart which shows a trend about actual data and also for the future it has to show forecasted values generated by R script ( for ex.: fit = nnetar(rev(q$close)); rev(data.frame(forecast(fit,h=$(Forecast_Days)))[,1]))
Can it be done in one chart ?
We only was able to do this in two, first had the actual data from the data model second had the forecasted values.
We want to place the actual data and forecasted data in one chart and in one line, but when we tried this, the forecasted data always placed in the beginning of the line chart, not the end of it e.g. 2018 since it is a forecast.
So we have this:
But we want like this:
We also tried to binding the actual data with the forecasted data within R script and used calculation condition for the coloring, but the order of the rows of the result wasn't correct.