Analytics functions allow you to explore data using models such as trendline and cluster.
Function | Example | Description |
---|---|---|
Trendline |
|
Fits a linear or exponential model and returns the fitted values or model. The numeric_expr represents the Y value for the trend and the series (time columns) represent the X value. |
Cluster |
|
Collects a set of records into groups based on one or more input expressions using K-Means or Hierarchical Clustering. |
Outlier |
|
This function classifies a record as Outlier based on one or more input expressions using K-Means or Hierarchical Clustering or Multi-Variate Outlier detection Algorithms. |
Regr |
|
Fits a linear model and returns the fitted values or model. This function can be used to fit a linear curve on two measures. |
Evaluate_Script |
|
Executes an R script as specified in the script_file_path, passing in one or more columns or literal expressions as input. The output of the function is determined by the output_column_name. |