Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
problem with sum for timestampdiff
Answers
-
Sure; -
case when 'WhateverConditionYouNeedHereIsTrue' then your FormulaHere else 0 end
Make the aggregation on it sum.
0 -
Also, if Dim Person has more than one person per person id then that is the least of your problems.
You need some kind of SCD functionality to make your employee 1:1 in all time periods, unless you are saying that the result you posted previously would work if you had made it; -
Period / Employee / Age??
0 -
This is looking more and more like a star modeling issue than a simple formula with a fetch/aggr ordering issue.
0
