Forecasting/Predictions

Cloud9QL supports the ability to forecast/predict future data points based on previous data history for any dataset.

To predict 1 point in the future:

select PREDICT(<field to predict>, <date field>, <start date for prediction>)

To predict multiple data point in the future:

select PREDICT(<Field to Predict>, <Date Field>, <Start Date for Prediction>,
    <Prediction Frequency>, <Prediction Data Points>)

To predict multiple data point in the future based on secondary dimension(s) (ie: grouping(s)):

select PREDICT(<Field to Predict>, <Date Field>, <Start Date for Prediction>,
    <Prediction Frequency>, <Prediction Data Points>)
group by <Dimension 1>, ..., <Dimension N>

This:

• Loads the data points from input data.
• Determines the optimum prediction model.
• Predicts future data point(s).
• <prediction frequency> is in the format of <Number><TimeUnits> for example 1d means daily 2m specifies every 2 months.
• <prediction model> you can choose a specific model to be applied from one of the following supported models (case-sensitive):
  • Regression
  • PolynomialRegression
  • MultipleLinearRegression