Using Multiple Dropdown Menus to Filter Large Amounts of Data

Hello, I’m new to working with plotly and need some help with the coding logic of using multiple dropdown menus to filter through large amounts of data from an excel spreadsheet to display the information in 2 pie charts. The logic of the dropdown menus needs to change based on whatever the user selects in the first dropdown menu.

The order of dropdown menus needs to be:

  1. Application
  2. Server
  3. Benchmark
  4. Release date

Then below the dropdown menus are two charts. One pie chart will display Status1 results and the other pie chart will display Status2 results based on what is selected from the dropdown menus.

I will attach a link to a google spreadsheet to view sample data.
Sample Data