Forum Discussion
Absence Data Plotted as Lost Days Per Month
Hi, We're trying to create an absence dashboard for our to HR leadership team. We have data from our HR system which depicts one absence per line per employee number (covers a period of 36 months...
HI Anonymous,
Can you please provide more information to help us clarify your requirement?(e.g, data table structure, sample data, snapshots, expected result...)
Regards,
Xiaoxin Sheng
Hi,
Please see our raw data sample:
| Emp_No | Abs_Start_Date | Abs_End_Date | Con_Work_Days | Abs_Code | Abs_Duration_SAP | Abs_Illness_Code |
| 1234 | 27/11/2015 | 31/08/2016 | 3 | 2300 | 191 | Maternity |
| 5678 | 06/10/2016 | 30/05/2017 | 5 | 4001 | 236 | Cancer |
I've added the manual columns below in excel to plot the lost days in months:
| Emp_No | Abs_Start_Date | Abs_End_Date | Con_Work_Days | Abs_Code | Abs_Duration_SAP | Abs_Illness_Code | January 2016 | February 2016 | March 2016 | April 2016 | May 2016 | June 2016 | July 2016 | August 2016 | September 2016 | October 2016 | November 2016 |
| 1234 | 27/11/2015 | 31/08/2016 | 3 | 2300 | 191 | Maternity | 12.6 | 12.6 | 13.8 | 12.6 | 13.2 | 13.2 | 12.6 | 13.8 | 0 | 0 | 0 |
| 5678 | 06/10/2016 | 30/05/2017 | 5 | 4001 | 236 | Cancer | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18 | 22 |
My end goal is to be able to plot visualisations that say X days lost to absence in X month over a period of time etc. I'm new to BI and so not sure on what/how I can go about this or whether the excel addition is actually the best way to go?
Many thanks.