Categories
- All Categories
- Oracle Analytics Learning Hub
- 17 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 224 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 84 Oracle Analytics Trainings
- 15 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
How to show results within the past 30 days

JHaden3
Rank 3 - Community Apprentice
I'm new to OTBI. I have an analyses where I want to return data for all employees termed within the past 30 days. I want it show terminations 30 days ago, 29 day ago, 28 days ago down to 1 day ago. How can I apply a filter or formula that will do this? The field is "Worker"."Termination Date".
0
Answers
-
You could make a column using TIMESTAMPDIFF(SQL_TSI_DAY,"Worker"."Termination Date",CURRENT_DATE). This will create a "Days Ago" column for termination date.
0 -
Good idea and thank you! However, that returned only the date of the termination instead of a day count.
0 -
If functioning correctly, that function would just return the number of days between each term. date and the current date.
Something's amiss.
0 -
Thank you, I got it to work.
0