Oracle Analytics Cloud and Server

Products Banner

How to calculate LTIFR using Analytics Cloud?

Received Response
42
Views
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'

Essentially multiply the first calc by 1million, and divide it by the second calculation, with the correct figure showing for each month. When I enter the below as a calculation I don't get the expected figures and cannot work out where the resultant figure is coming from.

(FILTER(MSUM(EventsCount., 12) USING Event Classification (Full)='Lost Time Case')*1,000,000)/((MSUM Total Hours, 12))

Any help would be much appreciated, or even an alternative method to calculating LTIFR within OACs analytics.

Answers