arimax

1result = arimax resultSet generate measure1 as fmeasure1 with (parameters);

parameters can have these values:

• arimaOrder (required if seasonalOrder isn’t specified) Specify the order for the ARIMA model. For example, arimaOrder=(p,d,q), where p, d, and q are integers. The integer values must be between 0 and 5.

  p is the AR order, d is the degree of differencing, and q is the MA order.

  Note

• seasonalOrder (required if arimaOrder isn’t specified) Specify the seasonal order for the ARIMA model. For example, seasonalOrder=(P,D,Q,s), where P, D, Q are integers and s is the period. The integer values must be between 0 and 5. The s value must be 0 or between 2 and 24. s can only be 0 when P, D, and Q are also all 0.

  P is the seasonal AR order, D is the degree of seasonal differencing, Q is the seasonal MA order, and s is the seasonal periodicity.

  Note

• xreg (optional) External regressors or co-factors. For example, xreg=('col1','col2',...). The values for xreg must be measures. The maximum number of xreg fields allowed is 10.

• xregFutures (optional) Future scenario data for the xreg parameter as a map of values arrays. The number of values in each array must match the value for the length parameter. The key for each array value is the name of an xreg measure.

arimax also supports the following timeseries parameters, with the same meaning and behavior.

• length (required) Number of points to predict. For example, if length is 6 and the dateCols type string is Y-M, arimax predicts data for 6 months.

  If you want to use dateCols but your data stream has missing dates, use fill before using arimax.

  Note

• dateCols (optional) Date fields to use for grouping the data, plus the date column type string. For example, dateCols=(CloseDate_Year, CloseDate_Month, "Y-M"). Date columns are projected automatically. Allowed values are:

  • YearField, MonthField, "Y-M"
  • YearField, QuarterField, "Y-Q"
  • YearField, "Y"
  • YearField, MonthField, DayField "Y-M-D"
  • YearField, WeekField "Y-W"

• ignoreLast (optional) If true, arimax doesn't use the last time period in the calculations. The default is false.

  Set this parameter to true to improve the accuracy of the forecast if the last time period contains incomplete data. For example, if you’re partway through the quarter, arimax forecasts more accurately if you set this parameter to true.

• order (optional) Specify the field to use for ordering the data. Mandatory if dateCols isn’t used. By default, this field is sorted in ascending order. Use desc to specify descending order, for example order=('Type' desc). You can also order by multiple fields, for example order=('Type' desc, 'Group' asc).

  For example, suppose that your data has no date columns, but it has a measure column called Week. Use order='Week'.

  Specify either dateCols or order.

  Note

• partition (optional) Specify the column used to partition the data. The column must be a dimension. The arimax calculation is done separately for each partition to ensure that each partition uses the most accurate algorithm. For example, data in one partition can have a seasonal variation while data in another partition doesn't. The partition columns are projected automatically.

  For example, suppose that your sales data for raw materials contains the date sold, type of raw material, and the weight sold. To predict the future weight sold for each type of raw material, use partition='Type'.

• predictionInterval (optional) Specify the uncertainty, or confidence interval, to display at each point. Allowed values are 80 and 95. The upper and lower bounds of the confidence interval are projected in columns named column_name_low_95 and column_name_high_95.