Earliest Working Pattern Record

Question

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

Working Pattern - 52 weeks only.zip

Code Snippet (add any code snippets that support your topic, if applicable):

Dawn Cawston - CPS · Answer

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

Venkat Koduvayur-Oracle · Answer

Hi @Dawn Cawston - CPS

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