Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
AGO function on TIMESTAMPDIFF
Hi,
I have a problem with the operation of the formula in the analysis.,
I'm trying to use the functions AGO on operations SUM (TIMESTAMPDIFF ())
In my analysis I have:
Formule for NOW column:
SUM(TIMESTAMPDIFF(SQL_TSI_DAY, "Purchase Details"."Due Date", "Purchase Details"."Need By Date"))
Formule for AGO column:
AGO(SUM(TIMESTAMPDIFF(SQL_TSI_DAY, "Purchase Details"."Due Date", "Purchase Details"."Need By Date")),"Time"."Time"."Year",1)
And I get results:
.My question: is it possible to make it work?
Answers
-
Someone has any suggestions?
0 -
Doesn't seem to work through Answers with that formula but works fine as an RPD column with derived calc.
(Prodney / Admin123)
0 -
Hi Christian,
Thanks for reponse.
I analyzed your example, and in my opinion it falls short. This is your example:
In my opinion In 2012 row should be:
2012 || 993612 || 960672 || ...
Because the column YAGO should be the value of the previous year and are still the same.
0 -
choracy69 wrote: Hi Christian, Thanks for reponse. I analyzed your example, and in my opinion it falls short.
Christian Berg wrote:
Doesn't seem to work through AnswersThat's....precisely what I wrote. It does not seem to work through Answers. If you looked at the analysis you'd see that once it's with a formula like yours and once with a formula using a global variable.
0 -
Ok, I understand.
That's how it implement the RPD?
How to perform a column in a fact: TIMESTAMPDIFF (SQL_TSI_DAY, data1, data2) wherein the two dates are the dimensions. And then the function AGO also reluctance to act.0 -
Like any other calc and derived ago:
0 -
Thanks for response.
Ok that I create column with timestampdiff and add agregation sum for it - it works.
But I have formule in answer something like:
sum(TIMESTAMPDIFF(SQL_TSI_DAY,."Invoice Date", ."DUE_DATE") * "Invoiced Amount" BY "Business Unit Name", "Supplier Name") / sum("Invoiced Amount" by ""Business Unit Name","Supplier Name")
How can I implement it in RPD?
I can't use agreagtion sum for TIMESTAMPDIFF(SQL_TSI_DAY,."Invoice Date", ."DUE_DATE") becasue I need sum of TIMESTAMPDIFF(SQL_TSI_DAY,."Invoice Date", ."DUE_DATE") and Invoiced Amount for each Business Unit/Supplier.
And when I use AGO function on sum(TIMESTAMPDIFF(SQL_TSI_DAY,."Invoice Date", ."DUE_DATE") * "Invoiced Amount" BY "Business Unit Name", "Supplier Name") - not work.
0 -
Why do you insist on using Answers?
Understand your formula. Split it up. Create appropriate columns in the RPD and then calculate.
"Invoiced Amount" BY "Business Unit Name" ... that's a level-based measure
"Invoiced Amount" by ""Business Unit Name","Supplier Name" ... that's another LBM
AGO is an AGO
etc.
The RPD is there to manage these things in a logical way rather than in one long formula sausage.
0