Growth Rate Calculations for Hire & Termination

Nupur Joshi-Oracle

Summary

Calculate quarterly , half-yearly & yearly Hire & Termination growth rate

Content

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. 

SantoshKumarBhairi

 hi Nupur,

Thanks for the great post. 

Do you have a similar .catalog file that can be used in Fusion HCM?

thanks,

Santosh

Nupur Joshi-Oracle

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.

Regards,

Nupur Joshi

SantoshKumarBhairi

Thank you, Nupur.

Nupur Joshi-Oracle

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.

SantoshKumarBhairi

That would be nice. Can you please share formula/sample calculation for the metrics mentioned Growth Rate screenshots? Thank you.

Nupur Joshi-Oracle

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.

 

Regards,

Nupur Joshi

 

SantoshKumarBhairi

Thank you Nupur. Much appreciated.

MeganTerrellHowmet

Great content! Thanks, @Nupur Joshi-Oracle