Skip to main content
DD-HLT-002 Inpatient Efficiency and Billing Get the data →
DD-HLT-002-Q014 Easy

Top department by collections allocated to encounters

Which department has the highest total collections allocated to encounters, and what is its value? Break ties by lowest DepartmentID.
Expected
One row: DepartmentID, total; descending total, ascending ID · Ranked bar chart
Tables
FactBilling, FactAdmissions, DimDepartment · columns
  • FactBilling
  • FactAdmissions
  • DimDepartment
  • CollectedSAR
  • EncounterID
  • DepartmentID

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.

Create a free account Sign in