nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

OAC DV - Add linear Regression functionality

Thomas HYRIEN

Added linear regressions in the Analysis section, then forecast for certain visualizations such as curves (see the example on the right). In addition to the forecasts already present such as ARIMA, SARIMA, ETS, etc.

Find more posts tagged with

Needs Votes

Status: Needs Votes

Comments

Brendan Tierney

Yes this would be useful and some additional regression lines in other visualizations would also be helpful, along with an AB line

Philippe Lions-Oracle

Thanks @Thomas HYRIEN and @Brendan T

currently using right-click trendline, you can add a linear(regression)/poly/expo trendline on the viz directly, see below, that should already help with the initial question. As for slope and intercept (was that your question ?) these will are provided when the trendline is built on a scatter plot. But when the trendline is using date, X is then normalized to a sequential number and A&B become conventions (funtionally meaningless). Let me know if this does not answer your question

Thanks

Brendan Tierney

https://community.oracle.com/products/oracleanalytics/discussion/comment/71312#Comment_71312

Thanks Philippe

Thomas HYRIEN

Hi,

Thanks,

We would like some additional forecast models in the list in addition to ARIMA, SARIMA, ETS, etc.

Brendan Tierney

While additional algorithms are being requested there is a fuller list of what could be added (some already there)

Autoregression (AR): Predicts future values based on past values of the same series.

Moving Average (MA): Uses the average of previous data points to smooth out fluctuations and identify trends.

ARIMA (Autoregressive Integrated Moving Average): A popular forecasting model that combines AR and MA concepts, often used for non-stationary time series after differencing to make them stationary.

SARIMA (Seasonal ARIMA): An extension of ARIMA designed to handle data with clear seasonal components.

Exponential Smoothing: A family of methods that give more weight to recent observations, including methods like Holt-Winters that capture trend and seasonality.

Vector Autoregression (VAR): An extension of AR for modeling multiple related time series.

LSTM (Long Short-Term Memory) Neural Networks: A type of recurrent neural network well-suited for capturing complex temporal dependencies in time series data.

Prophet: Developed by Facebook, this is a robust forecasting tool designed to handle data with strong seasonal effects and missing values, and is also effective with holiday events.

XGBoost: An efficient and powerful gradient boosting algorithm that can be adapted for time series forecasting on tabular data.

Top Leaders

Top Ideas

Version history and restore for workbooks
Right now once you save a workbook, that's it. If you (or someone else with edit access) changes a canvas, deletes a calc or messes up a filter and saves, there's no easy way to get back to how it was. The options are digging out an old .dva export if you happened to take one, or asking an admin about a snapshot, which…
Allow us to customize the user button menu options in OAC
There are more menu options made readily available by default to non-admin users that we wish to restrict. It seems this functionality, to control menu options in the user button menu on the upper-right-hand-side of OAC (DV), is not currently available. Can we be given the ability to customize this menu? Ideally via…
Allow us to delete unwanted NSAW pages and watchlists
Right now, OAC offers pre-built pages and watchlists related to NSAW. At our University, we do not need these pages, and we want to delete them entirely. We've been told in response to our SR that all we can do is keep "Access" limited to only the default admin and sysAdmin roles. This prevents regular users from seeing…
Include a "Show Where Used" option on Workbook objects
It would be nice to have a way to right click on an object (subject Area, Column, Calculation, etc.) in the Data Panel and show where that object is referenced in a workbook = canvas, visualization, filter, calculation, data action, etc.) In Workbooks with multiple canvases and multiple subject areas, we are left to hover…
Save AI-detected anomalies and insights as a reportable dataset
When Oracle Analytics AI features find an anomaly, trend or key driver, let authors save those results as a dataset or subject area. Each run would add rows with the metric, the date found, the expected versus actual value, the severity, the main drivers and the filters applied. Authors could then build workbooks, schedule…