Skip to content
JustAsk Docs

Generating forecasts with AI

The JustAsk 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 JustAsk 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 JustAsk Agent will generate a new query if needed, analyze the query results, and generate a statistical forecast based on historical patterns in the data.

How it works

Section titled “How it works”

When you ask the agent to forecast or project data:

Step 1

The JustAsk Agent extracts the time-series data from your query results or runs a new query if needed

Step 2

It applies statistical forecasting models to identify trends and patterns

Step 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.

Step 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

Section titled “Example prompts”

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

Basic forecasting

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

Specific metrics

Section titled “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

Section titled “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

Section titled “Next steps”