DRAG DROP -
You have a dataset that contains daily sales by business segment from 2017 to the present.
You want to use monthly historical trends to predict sales by segment in the future.
Which three actions should you perform in order?
(Place the three correct options in order Use the arrows to move Options to Answer Area Use Answer Area arrows to re-order the options.)
Answers it incorrect. It should be: Put Order Date on columns and segment on rows. -> Aggregate the data to month year -> use forecasting
Add the date to the columns and segment to rows -> Aggregate the data to month and year -> Drag Forecast (tested)
Add the date to the Columns shelf. Add the segment and the sales to the Rows shelf. → This sets up the visualization structure. From the Analytics pane, drag Forecast to the worksheet. → This adds the forecasting model based on time-series data. Aggregate the date to month and year. → Ensures forecasting is done on a monthly basis, aligning with your use case.