How would you design a three stage bar chart drill down?

I'm designing a drill-down chart for management to analyze heat trends that are impacting their staff across multiple factories.

The images show the intended flow in which they would be using the charts.

Chart 1 - the staff groups X exposure to high heat (across all factories) after selecting 1 staff group

Chart 2 - the list of factories where the selected staff groups had gotten high heat notifications.

After selecting 1 factory

Chart 3 - the amount of notifications the selected staff group in the selected factory receive across the last 3 months.

Is this flow intuitive to the user? Is there a way I could make users get to the same level of detailed drill down in a simpler way? I'm also trying to get them within a single screen so users wont have to scroll back and forth.