Categories
- All Categories
- Oracle Analytics Learning Hub
- 33 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 255 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 96 Oracle Analytics Trainings
- 16 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
