Forum Discussion
Human Resources - Absence Reporting
Hi everyone
I'm doing a project for our HR team. I get sent 2 monthly reports that show current staff details (meaining I can calculate headcount) and absence data. I need to be able to show the % of staff that were absent in each month, based on the headcount in that particular month.
Does anyone have any ideas of how this can be done?
Many thanks
James
8 Replies
Hi Anonymous ,
Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Hi Frank
There is quite a bit of confidential data in the data set. But, to give you an idea of the datasets I have a table of Employee information and a table of absence information.
The employee table contains:
- Employee name
- Department they work in
- Start of employment
- End of employment (blank if they are still employed by the company)
- Salary
- Contracted hours
The absence table contains:
- Employee name
- Absence start date
- Absence end date
- Total working hours absent
- Absence type (sickness / holiday)
- Absence reason (if sick), e.g Flu
The expected result is:
- To see the % of serving employees that have been sick, YTD.
- To see the % of employees that have been sick in any given month this year, only for employees serving in that month.
I hope this helps and gives a bit of clarity & thanks for your time.
James
