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.