Hi,
I couldn’t find a report that would support us in calculating different numbers when it comes to the age of people. E.g. we would like to know the average age of people. How do I get this information out of Personio? Thank you.
Edda
Answered
How to count average age within the company?
+14- Communicator
- 118 replies
Best answer by Daniele
Good morning
You can visualize this information through our custom reports.
Just create a point in time report and add the “age” attribute in a column.
Once your custom report is created, you will see all your employees and their age at a glance.
Now, export the report as an xlsx file and open it with excel (or your preferred spreadsheet software) to calculate the average.
Calculating the average with a spreadsheet is very quick and easy - I will briefly explain it here, just in case anybody else is reading this and needs a quick how-to:
There are two options:
- When you select all the numbers in the age column, it will display the average value in the bottom right.
- Otherwise you can use the
=AVERAGEformula.
If you want to learn more about Custom Reports, you can find some useful examples in the Help Center Article: Best Practice: Custom Reports
I hope this helps!
Have a lovely day,
Daniele
+23- Community Admin
- 955 replies
- Answer
Good morning
You can visualize this information through our custom reports.
Just create a point in time report and add the “age” attribute in a column.
Once your custom report is created, you will see all your employees and their age at a glance.
Now, export the report as an xlsx file and open it with excel (or your preferred spreadsheet software) to calculate the average.
Calculating the average with a spreadsheet is very quick and easy - I will briefly explain it here, just in case anybody else is reading this and needs a quick how-to:
There are two options:
- When you select all the numbers in the age column, it will display the average value in the bottom right.
- Otherwise you can use the
=AVERAGEformula.
If you want to learn more about Custom Reports, you can find some useful examples in the Help Center Article: Best Practice: Custom Reports
I hope this helps!
Have a lovely day,
Daniele
Join the Personio Voyager Community!
If you are a Personio customer please use the same email address for registration as in your Personio account. By doing so we can help you faster if we might need to check something in your account. Do you already have an account? > Login
! Your public username cannot contain any personal information such as email or other private information! You can't change your username after registration.
Welcome to the Personio Voyager Community!
This is our service and networking community for all Personio users and HR Professionals. If you have not registered yet, please select "create an account"
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.