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
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
