Skip to main content
DD-HLT-001 Outpatient Service Performance Get the data →
DD-HLT-001-Q027 Medium Time series

Monthly trend of completed length-of-stay days

How does completed length-of-stay days change month by month? Show every month and identify the highest month, breaking ties by earliest month.
Expected
24 rows: YearMonth, total; ascending month · Line chart
Tables
FactOutpatientVisits, DimDate · columns
  • FactOutpatientVisits
  • DimDate
  • LengthOfStayDays
  • 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