Spreadsheet Dashboard

You are required to build a dynamic dashboard using the provided data in google spreadsheet (using vlookup, hlookup, index, match, sumifs, countifs etc.)
Problem Statement:
• Clean the data
• Create a global filter of State & Date for viewing the data
• Plot the distribution of the current status of the patients, according to the global filters selected
• Plot the gender and age distribution of the patients
• For a particular date, plot the state-wise, city-wise, and district-wise distribution of patients. The plots should be dynamic and hierarchical (if you select a state from the plot, the citywise distribution should change. Similarly, if you select a city from the city plot, the district-wise distribution should change)
• Display the nationality distribution for the patients, according to the global filters selected
• Plot the distribution of the duration of infection for the patients. You can choose your own ranges (There should be min - 4 and max- 6 categories for the duration)
• Add functionality to see the type of transmission for the selected range of duration of infection