How to calculate LTIFR using Analytics Cloud?

User_EZQYG

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.

User_EZQYG

Example in picture, looking at October 18, looking to calculate 51,000,000/3,086,303.55 = 16.52, but i'm getting the result 2.28.

User_EZQYG

Also tried de-constructing the formula and removing dates from the visual and still not getting expected results.  105,000,000/8,629,050.31= 12.17, not 48.21.