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 for any help!