Function Finder

Quick reference to all Forecast extension functions. Find the right function for your task.

Function Naming: All functions use the anofox_fcst_ts_* prefix. Short aliases (e.g., ts_forecast_by) are also available.

Categories

Exploratory Data Analysis

Profile your time series data

statsquality_reportstats_summary

Data Quality

Multi-dimensional quality assessment

data_qualitydata_quality_summary

Data Preparation

12 functions for cleaning and transforming data

fill_gapsdrop_shortfill_nulls+9 more

Diagnostics

Period detection, decomposition, peaks, changepoints

detect_periods_byclassify_seasonalitydetrend_by+4 more

Cross-Validation

8 functions for backtesting and CV splits

cv_folds_bycv_forecast_bycv_hydrate_by+5 more

Conformal Prediction

11 functions for distribution-free intervals

conformal_predictconformal_calibrateconformal_evaluate

Exogenous Variables

Incorporate external predictors

forecast_exog_by

Hierarchy Management

Multi-level key handling for forecasting

combine_keyssplit_keysaggregate_hierarchy

Features

Extract 117 time series characteristics

featuresfeatures_listconfig_from_json

Models

32 forecasting algorithms for any data type

AutoETSAutoARIMATBATSTheta+27 more

Metrics

11 forecast accuracy and error metrics

MAERMSEMAPEMASE+7 more

All Functions

All CategoryConformalCross-ValidationData PreparationData QualityDiagnosticsEDAFeaturesForecastingMetrics

Function	Description	SQL Signature	Category
anofox_fcst_ts_forecast_by	Multiple series forecast	(table, group, date, value, model, horizon, freq, params) -> TABLE	Forecasting
anofox_fcst_ts_forecast_exog_by	Multi-series forecast with exogenous	(table, group, date, value, x_cols, future, ...) -> TABLE	Forecasting
anofox_fcst_ts_stats_by	Per-series statistics (36 columns)	(table, group, date, value, freq) -> TABLE	EDA
anofox_fcst_ts_quality_report	Quality assessment from stats	(stats_table, min_length) -> TABLE	EDA
anofox_fcst_ts_stats_summary	Dataset-level summary	(stats_table) -> TABLE	EDA
anofox_fcst_ts_data_quality_by	Multi-dimensional quality scores	(table, group, date, value, n_short, freq) -> TABLE	Data Quality
anofox_fcst_ts_data_quality_summary	Quality summary across series	(table, group, date, value, n_short) -> TABLE	Data Quality
anofox_fcst_ts_detect_periods_by	Multi-method period detection	(table, group, date, value, params) -> TABLE	Diagnostics
anofox_fcst_ts_classify_seasonality_by	Classify seasonality type	(table, group, date, value, period) -> TABLE	Diagnostics
anofox_fcst_ts_classify_seasonality	Classify seasonality (single)	(table, date, value, period) -> TABLE	Diagnostics
anofox_fcst_ts_mstl_decomposition_by	MSTL decomposition	(table, group, date, value, periods[], params) -> TABLE	Diagnostics
anofox_fcst_ts_detrend_by	Remove trend	(table, group, date, value, method) -> TABLE	Diagnostics
anofox_fcst_ts_detect_peaks_by	Detect local maxima	(table, group, date, value, params) -> TABLE	Diagnostics
anofox_fcst_ts_analyze_peak_timing_by	Analyze peak timing	(table, group, date, value, period, params) -> TABLE	Diagnostics
anofox_fcst_ts_detect_changepoints_by	Multi-series changepoints	(table, group, date, value, params) -> TABLE	Diagnostics
anofox_fcst_ts_features_by	Extract 117 features	(table, group, date, value) -> TABLE	Features
anofox_fcst_ts_features_list	List available features	() -> TABLE	Features
anofox_fcst_ts_features_config_from_json	Load feature config (JSON)	(path) -> MAP	Features
anofox_fcst_ts_features_config_from_csv	Load feature config (CSV)	(path) -> MAP	Features
anofox_fcst_ts_mae	Mean Absolute Error	(actual[], predicted[]) -> DOUBLE	Metrics
anofox_fcst_ts_mse	Mean Squared Error	(actual[], predicted[]) -> DOUBLE	Metrics
anofox_fcst_ts_rmse	Root Mean Squared Error	(actual[], predicted[]) -> DOUBLE	Metrics
anofox_fcst_ts_mape	Mean Abs Percentage Error	(actual[], predicted[]) -> DOUBLE	Metrics
anofox_fcst_ts_smape	Symmetric MAPE	(actual[], predicted[]) -> DOUBLE	Metrics
anofox_fcst_ts_mase	Mean Abs Scaled Error	(actual[], predicted[], baseline[]) -> DOUBLE	Metrics
anofox_fcst_ts_r2	R-squared	(actual[], predicted[]) -> DOUBLE	Metrics
anofox_fcst_ts_bias	Forecast bias (mean error)	(actual[], predicted[]) -> DOUBLE	Metrics
anofox_fcst_ts_rmae	Relative MAE	(actual[], predicted[], baseline[]) -> DOUBLE	Metrics
anofox_fcst_ts_quantile_loss	Quantile loss	(actual[], predicted[], quantile) -> DOUBLE	Metrics
anofox_fcst_ts_coverage	Interval coverage	(actual[], lower[], upper[]) -> DOUBLE	Metrics
anofox_fcst_ts_fill_gaps_by	Fill missing timestamps	(table, group, date, value, freq) -> TABLE	Data Preparation
anofox_fcst_ts_fill_forward_by	Extend series to target date	(table, group, date, value, target, freq) -> TABLE	Data Preparation
anofox_fcst_ts_drop_constant_by	Remove constant series	(table, group, value) -> TABLE	Data Preparation
anofox_fcst_ts_drop_short_by	Remove short series	(table, group, min_length) -> TABLE	Data Preparation
anofox_fcst_ts_drop_gappy_by	Remove gappy series	(table, group, value, max_gap_ratio) -> TABLE	Data Preparation
anofox_fcst_ts_drop_zeros_by	Remove all-zero series	(table, group, value) -> TABLE	Data Preparation
anofox_fcst_ts_drop_leading_zeros_by	Remove leading zeros	(table, group, date, value) -> TABLE	Data Preparation
anofox_fcst_ts_drop_trailing_zeros_by	Remove trailing zeros	(table, group, date, value) -> TABLE	Data Preparation
anofox_fcst_ts_drop_edge_zeros_by	Remove edge zeros	(table, group, date, value) -> TABLE	Data Preparation
anofox_fcst_ts_fill_nulls_const_by	Fill NULLs with constant	(table, group, date, value, fill_value) -> TABLE	Data Preparation
anofox_fcst_ts_fill_nulls_forward_by	Forward fill (LOCF)	(table, group, date, value) -> TABLE	Data Preparation
anofox_fcst_ts_fill_nulls_backward_by	Backward fill (NOCB)	(table, group, date, value) -> TABLE	Data Preparation
anofox_fcst_ts_fill_nulls_mean_by	Fill with series mean	(table, group, date, value) -> TABLE	Data Preparation
anofox_fcst_ts_diff_by	Differencing transformation	(table, group, date, value, order) -> TABLE	Data Preparation
anofox_fcst_ts_cv_folds_by	Create CV folds	(table, group, date, value, n_folds, horizon, params) -> TABLE	Cross-Validation
anofox_fcst_ts_cv_forecast_by	Forecast on CV folds	(folds, group, date, value, method, params) -> TABLE	Cross-Validation
anofox_fcst_ts_cv_split_by	Custom fold boundaries	(table, group, date, value, cutoffs, horizon, params) -> TABLE	Cross-Validation
anofox_fcst_ts_cv_hydrate_by	Add features to folds	(folds, source, group, date, features[], params) -> TABLE	Cross-Validation
anofox_fcst_ts_conformal_by	Grouped conformal prediction	(backtest, group, actual, forecast, point, params) -> TABLE	Conformal
anofox_fcst_ts_conformal_calibrate	Calibrate conformity score	(backtest, actual, forecast, params) -> TABLE	Conformal
anofox_fcst_ts_conformal_apply_by	Apply score to forecasts	(forecasts, group, forecast_col, score) -> TABLE	Conformal
anofox_fcst_ts_conformal_coverage	Empirical coverage	(actuals[], lower[], upper[]) -> DOUBLE	Conformal
anofox_fcst_ts_conformal_evaluate	Full interval evaluation	(actuals[], lower[], upper[], alpha) -> STRUCT	Conformal

Showing 53 of 53