Forecasting
Add a new page and call it Forecasting
Copy & Sync the date slicer to the new page.
Add a Line chart visual.
Set the Axis to Date from the Date Table.
Set the Values to Total Including Tax from the OrderDetails table.
Under the VISUALIZATIONS pane, select the analytics icon.
Expand Average Line then select +Add.
Set Measure to Total Including Tax
Go to the analytics icon.
Select Forecast > +Add
enter the following details:
Seasonality is set to 365 points because our data is at day level, and we have a year’s worth of data to base forecasting on.
Your report should look like this:
Forecasting
- Only works with a line chart
- The X-Axis must be of type Date
- Requires at least 6 data points
- Can only have 1 series of data on the line chart
- Doesn’t work if you’ve drilled down on a date hierarchy. Switch the X-axis to “Date”