Oracle Analytics and AI

JT_DC_2023

Hello everyone,

I’m currently working with Fusion Data Intelligence, and I’m trying to create a graph that shows exit projections (employee terminations/retirements) for each month and year.

My Data:

• Current Columns: person number, termination date, retirement date

What I Want to Achieve:

I’d like to generate a projection of exits per month, where the exit could be either a termination or retirement, depending on which comes first. Specifically, I want to:

1. Identify the first exit date for each employee (either from the termination date or retirement date).
2. Group the exits by month and year to display the number of exits for each period.
3. Visualize this data in a graph, with the X-axis showing the year/month and the Y-axis showing the number of exits.

Any advice or examples would be greatly appreciated!

Thanks in advance for your help!

Best regards

Rajesh L-Oracle

Hi JT_DC_2023,

Thank you for posting your question in Oracle Fusion Data Intelligence(FDI) HCM Product Community.

We suggest using Workforce Core subject area for your requirement :
In Workforce Core subject area, a daily snapshot of the active worker record is maintained. For example: If a worker was active between 1-Jan-2022 to 31-Dec-2022 then there will be 365 records of that worker. The snapshot includes the worker’s personal, employment and assignment information. When a worker is turned inactive due to termination then the termination record is captured as an event. From the next day of termination, the daily snapshot will not capture the inactive worker’s record.
You can also use Active vs Inactive Headcount: Active Headcount provides the data of the workers that have the assignment status as Active. Inactive Headcount provides the data of the workers that have the assignment status as Inactive.

In FDI, we also have Termination metrics based on the Termination Date.
Termination Count(Termination Date)
Voluntary Termination Count(Termination Date)
Involuntary Termination Count(Termination Date)

More Details can be found in FDI Docs:
HCM—Workforce Core - This table describes all the Workforce Core metrics for Headcount and Termination:

https://docs.oracle.com/en/cloud/saas/analytics/24r3/fahia/chapter-subject-areas.html#GUID-8E553DD0-8C57-438A-833E-1AE7FCB509C3
If you would like to have OOB/Standard content & visualization for your business requirements please share your suggestions in following FDI IdeaLab :

https://community.oracle.com/products/oracleanalytics/categories/idealab-fusion-analytics

Hope the above information was helpful.
regards,
-Rajesh