Termination Headcount from Trend real Time not giving correct headcount — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Termination Headcount from Trend real Time not giving correct headcount

edited Nov 7, 2024 1:58PM in Reporting and Analytics for HCM 15 comments

Summary:

I'm working on an OTBI analysis to calculate and display the turnover percentage for leavers over the last two years as a line graph. The objective is to show two distinct lines:

  1. Turnover percentage for the last 12 months (labeled as "current year")
  2. Turnover percentage for the 12 months before that (labeled as "previous year")

Details:

  • Y-axis: Leaver headcount
  • X-axis: Leave month (formatted as MMM) with a rolling 12-month display, where the most recent full month appears on the far right of the graph.

I'm using the Workforce Trend Real Time subject area to retrieve data fields such as period start headcount, period end headcount, average headcount, leaver count, and turnover percentage within a specified date range. However, the termination headcount I'm getting is significantly lower than expected. I'm currently using

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!