This post walks through how to create a drill-down table in Tableau so you can see different levels of granularity at the same time as well as how to create a custom button to go back to the default view.
How has the UK responded to lockdown?
This blog post walks through some of the design and UX choices in making this visualisation about how different areas of the UK have responded to lockdown.