We are seeing conflicting information regarding how Headcount Turnover is calculated.
The Subject Area page says this (no reference to "daily").
The excel spreadsheet on the data lineage says this ("daily avg head count"):
It is correct. All depends on what time grain you are reporting.
Assume today is Feb 10
Jan 1 Headcount = 100 Jan 31 Headcount = 110 Assume that 5 were terminated and 15 were hired in January Assume that 2 were terminated on Feb 7 and 3 were hired on Feb 9
If you have "Month" on your report, you will see:
Month, Avg HDC, HDC Turnover Jan, (100+110)/2=105, (5/105)*100=4.76% Feb, (110+109)/2=109.5, (2/109.5)*100=1.83% Because we are on Feb 10 (our initial assumption), the period end date would be Feb 10, and not Feb 28.
If you have "Date" on your report, you will see the following for Feb (not giving for Jan coz that will be 31 records)
Date, Avg HDC, HDC Turnover Feb 1, 110, 0% Feb 2, 110, 0% Feb 3, 110, 0% Feb 4, 110, 0% Feb 5, 110, 0% Feb 6, 110, 0% Feb 7, (110+108)/2=109, (2/109)*100=1.83% Feb 8, (108+111)/2=109.5, 0% Feb 9, 109.5, 0% Feb 10, 109.5, 0%
Hi @Raghavendra Raghunath-Oracle ,
Hope you are doing well.
Can you please assist here?
Thanks.
Thank you for the answers so far, but I think there is still some confusion regarding how this works when we look at it by year. For example, turnover rate in 2024. If we have an area that started the year with a headcount of 33, and ended the year with a headcount of 48, the calculation is averaging those two numbers for an average headcount of 40.5. However this area had a large increase in headcount mid year (up to 117) which is not accounted for if we are taking beginning and end of period. The true average daily headcount (averaging the headcount for each day of the time period, in this example year) was 68.
Avg HDC
If you have only YEAR as the time grain on your report, it will average out the headcounts as of 1/1/2024 and 12/31/2024, which according to you are 33 and 48 respectively. What happened during mid-year won't be addressed. And I don't see anything wrong in it. The real average HC for 2024 is essentially 40.5. That is my understanding.
Would be curious to see what Raghu has to say.
Hi All, thanks for engaging on this topic.
I agree with Sushanta's response above. The average depends on the grain of the query.
If year is the lowest grain then the headcount as of first day and last day of the year is considered for the average
If month is the lowest grain then the headcount as of first day and last day of the month is considered for the average
Some of our customers rely on Trailing Twelve Months Average Headcount. We do not have a seeded metric yet for that.
However, we have TTM Termination (Rolling 12 M) Metrics seeded.
using this, i had created a dv to compute the turnover using TTM Terminated metrics and Computed TTM Average headcount
I hereby share the same dv, take a look if it helps
refer the table on top
Raghu
Thank you for this update! It seems like the data lineage excel spreadsheet should be updated to say average headcount and not daily average headcount since it is not always daily. We will dig in to the response and example above and will follow up with any questions.
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
HI, I am trying to get data from the Enterprise Contracts - Contracts subject area in FDI. However, it is not returning any records when I use this subject area. Are there additional configurations or setup tasks needed to pull enterprise contracts data in FDI? I have checked the following: In Oracle fusion, I have access…
How to Inject external data (Business central data) into Oracle Autonomous lakehouse via SFTP connector in FDI?
OOTB subject area fields are not available in DEV and PROD. Existing workbooks display "Error Loading Data" and report that standard fields are cannot be found. Local Subject Areas also display "Schema listing not available". The issue appears to affect the FDI semantic layer/metadata across environments. Can anyone facing…
I’m currently facing an issue with the Absence data in FDI. For example, in the screenshot, the Approved Absence measure is showing 1, while the correct value in Fusion 1,560. A few points: This is the standard/prebuilt dashboard; no customizations were made. There is no date filter applied. The FDI refresh runs daily, so…
Report 1 :We do have FRS report with 7 to 8 columns.HTML veiw of the report showing extra space .how to fit the output to the report .There should not be space in the html report.Attaching the report output. Report 1 output : Report2 : We do have an FRS Report where one connection has all ledgers except CSG IND STAT…
