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

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
Comments
-
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.
0 -
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.
0 -
Simplify use for self-service users.
0 -
Indeed a must.
0 -
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.
0