Small Multiples Drilldown with hierarchy

To enable drilling down from department to workplace, you will need to adjust the drilldown functionality in your stacked line and bar chart. One way to do this is to add the workplace field as a secondary category axis in your chart.

To do this, click on your chart to select it and then go to the "Visualizations" pane. Click on "Axis" and then select "Category" under "Secondary." From there, add the workplace field as a category axis.

Once you have added the workplace field as a category axis, you should be able to drill down from department to workplace by clicking on the department and then selecting the specific workplace you want to view. You may need to adjust the formatting of your chart to make sure that the workplace labels are legible when displayed on the chart.