Skip to main content
DD-HLT-004 Hospital Network Performance and Capacity Planning Get the data →
DD-HLT-004-Q030 Hard Time series

Departments driving change in completed length-of-stay days

Which three departments contributed most to the year-over-year change in completed length-of-stay days in the latest year? Reconcile all department changes to the hospital total, using absolute changes rather than averaging growth rates.
Expected
DepartmentID, prior, latest, absolute change; descending change then ID; reconciliation total · Variance bridge
Tables
FactHospitalEncounters, DimDepartment, DimDate · columns
  • FactHospitalEncounters
  • DimDepartment
  • DimDate
  • LengthOfStayDays
  • DepartmentID
  • AdmissionDateKey
  • YearMonth

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.