Average Daily Census by Month in SQL Reporting Services
Posted on 2006-07-03
I am trying to make a report that will show the average daily census for our patients (health care org.)
This is what the report would look like:
June 238 (this number will be the average number of patients served per day in the month of June)
etc, rolling to 1 year previous
This is the data I have available: the patient's Start of Care date, and patient's Discharge date
Is it possible to get the information I want?