At work on approved leave

How many "Present" rows in FactAttendance fall on a date inside an approved "Annual leave" of the same employee (StartDate to EndDate)?

Expected: One whole number · KPI card
Tables: FactAttendance, FactLeave · columns

FactAttendance
FactLeave

WorkDate
Status
StartDate
EndDate
Topics: Risk & Controls Workforce & Payroll

Discussion

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

Join the discussion

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

Create a free account Sign in