Bed occupancy by ward

Looking to create a visual for bed occupancy for each ward, with drill down from year -> quarter -> week -> day for the following data     Have tried several ways but no luck   Many thanks...