To create a prediction of ongoing revenue for the next three months, which functionality should be used?

To generate a prediction of ongoing revenue for the next three months, utilizing a forecasting feature that extrapolates data trends over a specified timeframe is essential. Adding a forecast for approximately 90 periods leverages historical data patterns to project future values effectively. This method employs statistical algorithms to analyze seasonal trends, cycles, and variations in the data, allowing it to forecast future performance based on past behaviors.

This approach is particularly suitable when considering a rolling forecast or a need to assess potential future performance over a period that aligns with the planning and decision-making processes typical in finance and business operations. By extending beyond simple extrapolation or trend analysis, this method gives a comprehensive view of expected revenue, making it more robust for strategic planning.

In contrast, creating a custom calculation may not directly project future revenue but instead focuses on deriving values based on specified parameters or metrics. Adding a trend line is useful for visual representation but does not inherently calculate future values. Creating a reference line provides a point of comparison but does not generate predictive insights. Thus, the selection of the forecasting feature aligns best with the requirement to produce a revenue prediction over the next three months.