Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to access Global Filter value from Section Filter
Answers
-
PERIODROLLING("HCM - Workforce Core"."Facts - Workforce Events"."Termination Count", -13, 1)
0 -
sorry ... I had to poste sentence by sentence as above for some reason.
0 -
"but only one day's data is available to the whole workbook and we actually want the termination count for year of 2022." => Not exactly clear what the issue is but if you are looking to only retrieve year part of a date field then you can use YEAR(<yourdatecolumn>). This YEAR function will return just the year and you can then use this value in the filter definition.
0 -
for example "As of Date" on the top filter bar to 07/01/2022, which filter the workbook to this date only, including the Termination analysis section which only have one day's data to analyze too, which we need Terminations of CURRENT YEAR against the "As of Date", which would be 2022.
0
