I would like to plot a chart with x axis as date, y axis as sum of enrollment count. For dates which the data exist, it should give the actual values. For future dates, it should forecast the values. The forecast can be a regression line, or an average of the last fifteen days.
I have a list box, which would enlist the state. If I select a particular state(say X), then the above chart should reflect the actual and forecast data for that particular state.
Similarly, I have a list box which enlists the tehsil. I should be able to select a particular tehsil and get its corresponding actual and forecast data.
Would a trend line be OK for the forecasting or do you need something rather more sophisticated? I've not used them much but I believe there are several to choose from at the bottom of the chart Expression tab. If so, then just a standard chart with Date as the dimension and Sum([Enrollment Count]) should do the trick.
The trendline option at the bottom of the expression tab gives the trend only for the dates for which data exist. Is there anyway to get these trendlines to go ahead and plot for future dates(dates for which data does not exist) too?