For customers of our Position Management module.
The Turnover Rate widget displays the turnover rate and the number of terminations in a specified date range. This article explains how to add the Turnover Rate widget to your Positions Insights and configure the date range and time period so you can display the data most valuable to your organization.
Capturing Termination Data
Built begins storing turnover data as soon as your organization creates an account. To accurately record a termination, the employee status must be changed from active to terminated. Whether changed manually by an account admin or automatically through a data import, both methods require a termination date and a termination reason (voluntary or involuntary).
Note: Removing a position from the org chart or deleting a person from the People list does not record the individual as terminated. When terminating a person's employment, go to their Profile page and use the dropdown arrow next to their name before clicking Change Employee Status.
Adding the Turnover Rate Widget
To view your organization's turnover rate data, you must add the widget to your Position Management Insights.
From the main menu, navigate to the Positions page to view your position insights.
Click the + Add Widget button at the upper right corner of the page.
Select the Turnover Rate Widget card to add the widget.
Once added, click and drag the widget to configure its location on the page.
Selecting a Date Range
Go to the top right-hand corner of the widget to select which date range you would like displayed. You can choose between three date range options: All-Time, 1 Year (displaying the Past 12 Months), or Year to Date. The line chart, total turnover rate, and the number of terminations will be adjusted to reflect the data from the selected date range.
Specifying a Time Period
At the top of the widget, you can adjust your visualization to see the turnover rate by month, quarter, or year. Hovering over a designated point on the line chart will display a tooltip with the turnover rate and the number of terminations for the specified period. For example, if you want to see the turnover rate for a particular month, select to view the chart by month, then hover over any month within the date range you have displayed.
Calculating Turnover Rate
Turnover rate captures the percentage of people leaving an organization within a specified time frame. The equation below explains how Built calculates turnover rate using average headcount and termination data.
Calculating Turnover Rate:
Calculating Average Headcount
The Built turnover rate calculation uses the average monthly headcount for the specified time frame. For periods longer than one month, the calculation considers the average headcount for each month within that longer time period. This method provides a more accurate headcount number for extended periods, such as quarters or years. The calculations below demonstrate how the average monthly headcount informs the average quarterly headcount.
Calculating the average headcount for a given month:
Calculating the average headcount for the first quarter:
Please contact our Customer Success Team if you have a question or would like to see specific data added to our insights options.
Additional Resources