The Average Age KPI is one of a set of vital HR KPIs we have created in bob to help you track and analyze your organizational HR objectives, and optimize processes such as workplace management, employee programs, and more.
Located in the Retention category of KPIs in the Analytics module, the Average Age KPI provides you with the average age of all of your employees in the selected period. The KPI is calculated by the sum of age in years during a particular period of time, divided by the total number of employees during that time.
Learning about the average age of employees at your company can help you improve your diversity and inclusion. Knowledge about your people's average age empowers you to identify the needs of a particular type of workforce, as well. For instance you may find you have an aging workforce, and you'll be able to manage your people according to their specific needs.
How to use the Average Age KPI
When you head over to the Average Age KPI, you will be able to see your employees’ age in years during a particular month, quarter, or year along with a range of filters and groupings. Data is displayed for each period in the selected time range.
To get started with Average Age KPI, follow these steps:
Step 1: Set up category view settings
You can set bob to view KPI data for a particular month, quarter, or year displayed over any time period. Whenever you configure these settings, it will impact how all of the KPI categories will be showcased in bob.
Step 2: Configure the Average Age KPI
Define how you’d like to review the Average Age KPI data. You can choose from an array of analytics options to view your data, including condition-based filtering, several different chart types, and more.
To slice, dice and filter your data click on the Grouped By dropdown and choose what to focus on
Click on the arrow ∨ to the right of the chart symbol
Click on the desired chart type
Note: certain chart types may not be available in instances where they are irrelevant to the chosen data set.
Click the subgroups in the legend to deselect them from the view, and click on them again so that they reappear on the chart
Activate the Over time toggle to see the total sum of the KPI data over the entire period selected in the Date range described in Step 1. This will override the KPI category View setting.
Activate the Values toggle to showcase the numerical value of the data set
Note: activating or deactivating the Over time toggle impacts the available chart types
8. To add additional filters, click the three dot menu followed by Filter
a. Use the dropdowns to select fields and configure conditions to filter by
b. Click + Add condition to create additional rules and repeat as many times as you'd like
c. To remove a condition, hover over it, and click the trash icon that appears to the right of the condition
d. Press Apply
9. To reset your chart configurations, click the three dot menu followed by Reset
10. To download the chart, click the three dot menu followed by Download and then the file type you’d like to download it as. You can export a chart as a .png, .jpeg, .pdf or .svg file.
11. To see the in-depth employee data included in the KPI view you have configured, click View more details under the chart
a. Click on a part of the chart (e.g. one of the bars in a bar chart or a segment in the donut chart). The table below the chart will display the data that specifically matches the grouping you selected, showing all of the people that belong to that group.
b. Use the column picker found in the top right of the table to add or remove employee information in the table
c. Click on the download button to the right of the column picker to download the employee data either as an .xlsx or .csv file
d. Click Back at the top left of your screen to return to the dashboard
Tips for optimizing the Average Age KPI data
Make sure your employees' dates of birth are up to date
Verify your permissions include viewing other employees' work, lifecycle and personal sections
Need more help? If you're unsure about anything please send us a message through the chat icon below.