Calculate LTIFR & TRIFR for multiple companies
Hi Community, I need to be able to show on a dashboard the calculated LTIFR (Lost Time Injury Frequency Rate) & TRIFR (Total Recordable Injury Frequency Rate) rate for my own company as well as those of our subcontractors. My company is represented as 'JKL4' and needs to be separate; all other companies should have a combined rate. I also need this to be on a rolling 12-month basis, so the rate for Jan 2024 will take into account the hours worked and injuries recorded from Feb-23 to Jan-24, the Feb-24 will be from Mar-23 to Feb-24 and so on and so forth The data is coming from an online SharePoint list that has a lot of columns, but I only need to use six for the calculation Month Contractor Hours LTI (Lost Time Injury) RDI (Restriced Duty Injury) MTI (Medical Treatment Injury) LTIFR calculation (LTI only) TRIFR calculation (LTI, RDI, and MTI) I have included a link (link no longer available) the data I will be using. Only the contractor names have been changed; all other data is correct The parent table name is 'Tb_HSEQ_Stats'
