Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Earliest Working Pattern Record
Summary:
52 week working pattern start date is not reportable at the moment.
Content (required):
Each time the employee changes to a zero hours week there is a new working pattern start date. I can pull a list off of all the working patterns assigned to each of these employees but how do I narrow it down to the first record so as to see the original start date of the overall schedule
Version (include the version you are using, if applicable):
22D soon to be 23A
Code Snippet (add any code snippets that support your topic, if applicable):
Answers
-
Not sure whether you are able to resolve this issue.
If not, you can give it a try by creating a new column with expression in your report with a RANK function.
Idea is to Rank the employees based on the working pattern start date and filter rank=1 to get the first working pattern record to see the original schedule.
E.g.
RANK("Working Pattern Start Date" by "Person Id")
And further apply a filter on the report on this rank column to filter rank=1
Hope this helps
Regards,
Venkat
0 -
Hi Venkat,
Thank you for the suggestion which did place a ranking against the records however it has ranked the latest one as number 1 lol which means I would need to find the highest number rather than all the 1's.
I have tried the filter to the last 1 however it then only brings back one record for one person rather than a record for all the persons.
Will continue investigating and thanks for the input as it has helped tremendously
Dawn
0