Oracle Communities

Oracle Analytics and AI

Child Item

Calculating period-to-period growth with Oracle Analytics with just one click

Aaron Zhong-Oracle

Organization Name

Oracle

Description

Currently OAC can manually create period-to-period growth by using the following method.

https://blogs.oracle.com/analytics/show-growth-every-time-with-oracle-analytics

But it is still very complicated for self-service users.

In tableau, users can create do it with just one right-click, like the following:

Will we add this capability in OAC as well?

Thanks

Aaron Zhong

Use Case and Business Need

Being able to calculate period-to-period growth and growth rates is a common need in most analytics insight projects today.

Original Idea Number: 8e756de04e

Find more posts tagged with

Planned

Analysis and Data Visualization

Developers

Status: Planned

Comments

Michal Zima

Definitelly this feature should be there - althought BI Server has time-series function - ToDate and Ago, those functions cannot be used for "external" data sets in DV (just for calculations in DV projects, based on Subject Areas - due to a need for Time dimension). If those functions would be "exposed" for all data sets, this would solve the problem.

User_H27UG

Yes. It is a absolute necessity. Not only the period to period growth but all the quick table calculations shown in the screenshot need to be available and we need to be able to represent the absolute numbers as relative values as well.

FPonte

Simplify use for self-service users.

Wilian Perone

Indeed a must.

User_FR446

Is there better way to do this in 2023? What's noted here is fairly crude/lengthy given how critical it is to be able to create period over period metrics for any finance/performance analysis.