get earliest hire date by action type

Summary:

Hello,

I'm trying to get, in OTBI, a result of the earliest "Employee Hire Date", based on a specific HR action (Rehire in this case).

The Analysis is to get “Enterprise Hire Date” for all the employees except those who were rehired, and for them bring the “Employee Hire Date”.

The challenge is that an employee can have additional HR actions since the Rehire action, and then we might “miss” the Rehire and fetch the wrong date.

any ideas?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

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