Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 51 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 288 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 111 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How would a new column be generated in the analysis result
How would a new column be generated in the analysis result that would be based on two other existing columns/prompted input (i.e calculating number of days between effective start date and effective end date and then recording the difference as number of days in the new column)?
Answers
-
Welcome to Oracle Analytics and AI community.
Please check below threads:
OTBI Performance Tile Filter : How to get difference between 2 dates — Cloud Customer Connect
How to calculate difference between two dates in OBI? — Cloud Customer Connect
Thanks.
1 -
Hi @User_M2U6X,
You can easily achieve it using a calculated column.
Here's an example for you where 'Age in Post in Years' has been calculated using start date & today's date.
Please find below the Report XML that you can use as a starting point and might be useful for the understanding.
Hope this help.
Thank you.
1
