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

Monthly trend of collections allocated to encounters

How does collections allocated to encounters change month by month? Show every month and identify the highest month, breaking ties by earliest month.
Expected
60 rows: YearMonth, total; ascending month · Line chart
Tables
FactBilling, FactHospitalEncounters, DimDate · columns
  • FactBilling
  • FactHospitalEncounters
  • DimDate
  • CollectedSAR
  • EncounterID
  • 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.

Create a free account Sign in