Forum Discussion

AFultz's avatar
AFultz
New Member
4 years ago

Modified Census Count By Month using Admit/Discharge Dates

Hello,

 

I need to be able to show on a graph how many Cases an agency program has maintained each month. It is essentially a census count for the month, but I'm only supposed to include cases that have been in program for every day in the month. Anyone who has been admitted or discharged partway through the month needs to be excluded from that month's count. 

 

I have an Enrollment Report that lists each Case with an admit date and discharge date in the same row. Is there a Measure that would be able to accomplish this? Or another route?

 

Any guidance on this would be greatly appreciated!