Fusion Analytics Warehouse
Growth Rate Calculations for Hire & Termination
Calculate quarterly , half-yearly & yearly Hire & Termination growth rate
This DV uses hire headcount, voluntary termination headcount, involuntary termination headcount - month on month basis, and derives hire headcount in the last 3 months, 6 months & 12 months. This also calculates M/M growth rate & Y/Y growth rate for hire headcount & termination headcount.
This can also be extended to use any other events like promotion rates, transfer rates, or any other OOTB metric, calculated metric, or on an external file.
Please follow below steps to get started using these pre-built analyses for your organization.
1. Download.Dav file from this post
2. Log into your OAX instance.
3. Click on Import Project/Flow
4. Click on Select File button. This will open a browse window on your machine. Select the required files with .DVA extension.
5. Click on the Import button.
6. Once the import is successful, it will display the message "Import Successful". Click Ok.
Thanks for the great post.
Do you have a similar .catalog file that can be used in Fusion HCM?
Hi Santosh ,
You can surely create one in OTBI using Worker Assignment Event Real Time subject area. All MSUM formula remains the same you need to replace attributes used with one from the Assignment Event Subject area.
Limitation of OTBI is you get data for months where hire/termination events have occurred and this is the advantage of OAX over OTBI where you can plot data across all months.
Please do revert in case of any further queries on the same.
Thank you, Nupur.
Please do let us know in case of any query on building one with OTBI and we can surely help you with sample calculation to be used for Y/Y growth rate or 3 months/6 months view.
That would be nice. Can you please share formula/sample calculation for the metrics mentioned Growth Rate screenshots? Thank you.
Hi Santosh ,
PFB sample formula for calculations present in this post. The same can be used , replace hire headcount by relevant metrics, to calculate termination rates present in this post.
Hires 3 months ago - Msum(Hire Headcount,4)-msum(Hire Headcount,3)
% Y/Y Growth Rate in Hiring- Hire Headcount/(MSUM(Hire Headcount,13)-MSUM(Hire Headcount,12))-1
%M/M Growth Rate in Hiring - Hire Headcount/(MSUM(Hire Headcount,2)-MSUM(Hire Headcount,1))-1
Hope this helps you to answer any related business question.
Thank you Nupur. Much appreciated.
Great content! Thanks, @Nupur Joshi-Oracle