Hospital Bed Census Help

Hello   I am trying to show how many of our beds were filled on any given day and by program, i.e. "820 Stabilization".  The unique ID is the Patient ID.   Here is an example of file that the EMR...