Skip to main content
This feature is currently in beta. Reach out to Omni support to have it enabled for your organization.
The Omni Agent can generate statistical forecasts for time-series data using natural language prompts. Instead of relying on spreadsheet formulas, the agent uses deterministic forecasting functions to project future values based on historical trends. You can ask the Omni Agent to generate a forecast directly in the Workbook Agent. For example:
  • “Forecast revenue for the next 3 months”
  • “Project user growth for the next quarter”
  • “Predict sales trends for the next 6 months”
The Omni Agent will generate a new query if needed, analyze the query results, and generate a statistical forecast based on historical patterns in the data.

​
Requirements

The Use Omni Agent setting in AI settings must be enabled to use this feature.

​
How it works

When you ask the agent to forecast or project data:
1
The Omni Agent extracts the time-series data from your query results or runs a new query if needed
2
It applies statistical forecasting models to identify trends and patterns
3
It generates projections for the requested time period. When a forecast spans multiple periods, the agent first forecasts the remainder of the current period using daily granularity data, then forecasts the remaining periods at the granularity you requested.For example, if you ask the agent to forecast 2027, it first forecasts the rest of 2026 using daily historical data, then uses that result along with annual history to forecast 2027.
4
The forecast results are displayed in the workbook or dashboard
This approach uses deterministic forecasting functions rather than simple spreadsheet calculations, providing more accurate and statistically sound projections.

​
Example prompts

The following examples demonstrate the types of prompts you can use to generate forecasts with the agent.

​
Basic forecasting

  • “Forecast the next 3 months”
  • “Project this trend forward 6 months”
  • “Predict values for the next quarter”

​
Specific metrics

  • “Forecast monthly revenue for the next year”
  • “Project user signups for the next 90 days”
  • “Predict sales volume through the end of the year”

​
Analysis questions

  • “What will revenue look like in 6 months?”
  • “How many users can we expect next quarter?”
  • “Where is this metric headed?”

​
Next steps