You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to calculate LTIFR using Analytics Cloud?

Received Response
10
Views
2
Comments
edited Sep 11, 2019 5:22AM in Oracle Analytics 2 comments

Summary

Having issues combining 2 rolling totals calculations into an LTIFR Calculation

Content

I'm trying to calculate LTIFR using Analytics cloud (Total Lost time events from the last 12 months x 1,000,000 / Total hours worked from the last 12 months)

So far I have been able to calculate the correct rolling 12month total for lost time events:

FILTER(MSUM(EventsCount., 12) USING Event Classification (Full)='Lost Time Case') - Added this calc to a pivot visualisation as 'Values' with the months in as 'Rows'

and calculated correct rolling 12month total for total hours worked:

(MSUM Total Hours, 12) - Added this calc to a pivot visualisation as 'Values' with the months in as 'Rows'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!