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

Ability to disable the header row in tables and pivot tables
I am creating two tables in a freeform report and overlaying these tables to appear as one to the end user. I can hide the header titles by setting the font and highlight colour to the same as the background colour but it would be better if there was a functionality to disable the header row completely.
Ability to list the members/users of a custom role from the OAC -> Console-> Roles and Permissions
My organization needs a practical way to generate a comprehensive report listing all members—including both direct and inherited assignments—of every custom application role within the Oracle Analytics Cloud (OAC) Console’s Roles and Permissions area. Today, the only built‑in method is exporting one role at a time through…
Ability to fix the width of table columns to a set value
Currently you are able to change the width of a field in a table or pivot table by dragging the border but there is no option to manually fix it to a set value e.g. 100px. Justification: I am creating a report with two tables in freeform and need the field widths to have the same size when I overlay one table on the other.…
Allow Selection Steps in OAC Classic Analysis Reports to Support CASE Logic Conditions.
Request for an enhancement to Oracle Analytics Cloud (OAC) Classic Analysis Selection Steps on measure suppression for a specific calculated member created through Selection Steps. This idea is opened based on the directions from oracle CEAL team, for more details please find the below service request. SR -…
REST API for OAC App Roles
Hi, We use a lot of Custom App Roles in OAC Console and It would be easier to have an API to manage the members of App Roles.