Tableau Support Required

Hi,

I have attached a data set I receive, and need this converted into 2 dashboards in Tableau. Data set and image of how I want the data presented in Tableau attached.

The data I recieved will be consistent, so need a working solution which is repeatable. If the data has to be manipulated further, then it has to be done so in Alteryx or Tableau.

Again, I am not looking for a one off solution, I need something which is automated and repeatable.

To clarify:
Dashboard 1
Graph needs to show as separate bars by Ability:
- Times searched (from the demand tab) - Static bar
- No of Pokemon with Ability - dynamic bar when filter is applied
- Number of pokemon that are 'Free' - dynamic bar when filter is applied
- Number of pokemon that are 'Outside' - Static bar or dynamic (doesn't matter)
Multiple choice Ability and Ability Level Filter.

Dashboard 2
Need 3 filters to show Pokemon by ability and their ability level.
You should be able to search ability by single choice and ability level by multiple choice. The 3 filters have 'AND' condition.

Need solution by 10th June.

Thanks.