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

Calculating an Absence Rate for a Dashboard

edited Jul 17, 2018 2:16PM in Workforce Management 4 comments

Summary

Summing Normal Working Hours at same time as Duration for different populations

Content

I need to add our absence rate to a HR Dashboard.  This is calculated as Total Number of Hours Sickness / Total Available Hours.

We tend to use rolling 12 month figures.  So I'm using Workforce Mgmt - Absence Real Time to sum Duration for the time period.  However, when I bring back Normal Working Hours, it's only doing this for those people who've taken sickness leave.  I need to sum the Normal Working Hours (x52) for the whole population.  I've attached what I have so far.

Any ideas on how I can do this in a query so that I can link it to our Dashboard?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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