Forum Discussion

lc1's avatar
lc1
Helper III
7 years ago

Calculate Over Time Weekly Average by different categories

Hello,

I have an Over Time report by pay period and I'd like to create a matrix that indicates:

- Total number of employees working OT

- Average number of employees working less than 5 OT hours per week

- Average number of employees working 5-10 OT hours per week

- Average number of employees working over 10 OT hours per week

 

 Thank you

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    hello i would create the following measures 

     

    - Total number of employees working OT

    employees working OT = calculate(distinctcount(employee) ,filter(payperiodtable, OT Hours >= 0))

    - Average number of employees working less than 5 OT hours per week

    Average less then 5 OT hours = [employees working OT] / (calculate(distinctcount(employee) ,filter(payperiodtable, OT Hours <= 5))

    - Average number of employees working 5-10 OT hours per week
    Average btwn 5 - 10 OT hours = [employees working OT] / (calculate(distinctcount(employee) ,filter(payperiodtable, OT Hours > 5 && OT hours <=10 ))

    - Average number of employees working over 10 OT hours per week

    Average greater then 10 OT hours = [employees working OT] / (calculate(distinctcount(employee) ,filter(payperiodtable, OT Hours > 10))