Skip to main content

Understanding Rolling 12-Month Attrition Rates

  • Aug 16, 2025 6:45 PM UTC
  • 0 replies
  • 216 views
  • Translate All

This article explains how Bob calculates the rolling 12-month attrition rate based on a selected date range, using May 2024 as an example.

What is a rolling 12-month period?

A rolling 12-month period looks at a full year of data, ending with the selected month. It shifts forward one month at a time as you change the view.

How is the attrition rate calculated?

Attrition Rate = (Voluntary Leavers ÷ Average Number of Employees) × 100

To get the average number of employees, Bob uses this formula:

Average = (Headcount at start of period + Headcount at end of period) ÷ 2

Example: Calculating Attrition for May 2024

  1. Define the rolling window
    For May 2024, the rolling 12-month period runs from June 2023 to May 2024.

  2. Calculate average headcount
    Average = (Headcount as of June 2023 + Headcount as of May 2024) ÷ 2

  3. Count voluntary leavers
    Count the number of voluntary leavers between June 2023 and May 2024.

  4. Apply the attrition formula
    Attrition Rate = (Voluntary Leavers ÷ Average Headcount) × 100

Applying to Other Months

To calculate the rolling attrition for June 2024, shift the window forward one month to cover July 2023 to June 2024, and repeat the same steps.


Want to learn more about turnover metrics in Bob? Check out:

Retention dashboard
Turnover Rate KPI
What the Attrition Widget in Dashboards Takes Into Account