Query on Slope-Based Sales Trend Analysis in OAC

Question

Hi Team,

We have a requirement to identify customers whose sales have declined over a specific period in the last one year. Essentially, we need to compare the last 12 months of sales data and determine the trend — similar to how the SLOPE function works in Excel.

Could you please confirm if Oracle Analytics Cloud provides any built-in functionality for this type of analysis? Additionally, do we have any extensions or sample reports available for this scenario?

Thanks,

Jay

Gianni Ceresa · Answer

Don't use two accounts to post the same thing.

Your other account being "older", stick to that thread instead of this.

https://community.oracle.com/products/oracleanalytics/discussion/27396/query-on-slope-based-sales-trend-analysis-in-oac

Brendan T · Answer

This seems to be a duplicate post.  See the reply at

https://community.oracle.com/products/oracleanalytics/discussion/27396/query-on-slope-based-sales-trend-analysis-in-oac

you can also overlay data from different periods

also, the following is a bit of old post on something similar https://www.kpipartners.com/blog/bid/80921/statistical-analysis-using-linear-regression-in-obiee