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

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

How to calculate LTIFR using Analytics Cloud?

Received Response
12
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'

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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