Skip to main content
DD-HRM-003 Mizan Group: 1,000 People, One Payroll — HR & Payroll Analytics Get the data →
DD-HRM-003-Q015 Medium

Overtime as a share of pay

Overtime share = PayElement "Overtime" / all FactPayroll Amount, for 2025, by the company of the employee (DimEmployee). Which company has the highest share, and what is it? Answer the share, 2 decimals.
Expected
One percentage, 2 decimals · KPI card
Tables
FactPayroll, DimEmployee · columns
  • FactPayroll
  • DimEmployee
  • PayElement
  • Amount
  • EntityCode

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us

Create a free account Sign in