https://www.dropbox.com/s/exvabk4zssniqvo/trips_types.xlsx?dl=0
The follwoing is my data set. Total trips per day. The count has 2 types. casual and registered . I want to forecast the total rentals perday. and apply a slicer to the forecast so it adjusts accordingly to the data when i choose casual, and registered. I applied it using a video. But my problem is when i choose both , i get the total along with days being added . i.e my x axis should have always 1000 days, but when i pick both types, it becomes 2000.
can some one suggest me how to make if work properly.
the code i used here is
arima(deseasonal_cnt, order=c(1,1,8), seasonal=c(0,1,0))
seas_forecast1 <- forecast(fit_seasonality_1, h=30)
plot(seas_forecast1)
my sample data is attached in the link
