okay so this is part two for creating our dashboard so we are going to we are coming nearly to the end of the the entire course and we are going to create all the widgets that we need in our tab - which is country-specific and we can we should be able to have for example a breakdown filter I mean a filter in our dashboard where we can select the country we want and then once we select the country we want it's going to show the result for that country specifically okay let's start to do that so the first thing is to create the filter on in our dashboard but for dude to do that click on the menu here and then click on dashboard properties and then you can see here you have a breakdown source tab click on editor and then you will get to this page this is where we can add our breakdown so we do have a country breakdown source I'm going to add that one click on save and we should be able to see now a filter now you can see country breakdown now and you have select elements so we can select any country that we want for example I'm going to check if I have all countries I have single wave great so I have here all the functions ok so now let's start to build our our current country-specific tab all the videos that we need we are going to insert here the first widget is going to be a score featured so I'm going to create that warm okay so add that one and it's going to be for example total fun film cases so nothing different from what we have done previously so the previous video we have created widgets to see scores the global scores now we are going we are creating the same widget nothing different only different difference that we are going to see here is the is the follow element checkbox that you can actually see here so if you check that one you can select the breakdown which is the country breakdown okay and it will show the result for the country we are going to select okay the rest you can keep it and then click on submit [Music] prick so let's now see you speak any country that we want and see if we have the result is going to change or not selected here Afghanistan you can see you have a a result or Afghanistan okay so from now on all we need to do is to just create all our other scores okay total total active cases total dead cases to recover cases same process select here performance analytics new score and then click on the link give it a name for your visit so it's going to be totally cover cases select your indicator make sure you select pole element country breakdown and that's it and you haven't noticed when you select further element that you have one grade trade out feel just saying an aggregate okay so that means if you select that means like if you select two countries in your select elements it is basically going to add the results so if you select Afghanistan or Algeria for example it's going to actually put together so it's going to make this out okay for the score we don't have any choices we have to do like this this is by default we have that field grayed out so we need to it's going to be aggregate okay for scores so let's now finish with the our widgets I mean score widgets total did cases the indicator is total did cases here follow element country click on submit great so we have done with our score pitches we should be able to see all our for widgets now ok so here you can see the result for Austria okay let's now create another widget this time is going to be a time series widget and click on out here and it's going to show us the evolution of function cases active cases okay so that cases in a form of chart and it's going to be a column chart and if we are going to let's say apply the breakdown so we're gonna check here the box follow follow element and the breakdown country and we will have a different option Europe we can separate the result or aggregate okay so here time series the type it's going to be column chart give it a label okay pick a color it's a select here for element here and then country and you can see here we the field is not grayed out we can select between aggregate and separate what does that mean so if you select two countries and if you have separate here it's going to show the result separately okay so you will have two chart column chart within one feature okay so click on submit [Music] great so we do have now our the evolution of confident cases and for a certain period here and you can just drag and drop way you want and place it wherever you want and all we need to do from this point is to create all our other widgets like active cases evolution of active cases cover cases and so on I've got to do one thing which is example we can change here the date settings so we can put for a period of maximum period and then we can have a show date range selector okay that's going to allow you to change the period in the widget [Music] okay so now let's create our other widgets in the same it's the same process so let's do four record cases [Music] right so let's do now for evolution of active cases and we do the same for the dead cases [Music] right so we have now our second row perfect now the next thing is to create another time series widget but this time we are going to compare little bit to confirm cases and active cases with the area chart and we will have a boat chart in a same widget so let's do that so it's a new time series widget okay click on link here [Music] okay I gave here title you can see the title evolution of confirmed cases this is active cases so I'm gonna select here indicator a total confirmed cases so let's give it a label here pick a color [Music] so follow elements country show multiple elements I'm going to select here for example aggregate and the period max and I check the box show date range collector and it's going to be an aerial shot okay click on summit I should have a new year charge now right so you can see here we have our confirm cases this is the evolution of confirmed cases in an area chart and we can add one more visit here each other indicator which is going to be our active cases on the same so let me just rename the given another label here it's going to be confirmed cases that's a right one save that one and then let's add our widget indicator so it's going to be at all active cases [Music] and follow element [Music] okay so pick a color here so label is going to be for example active cases and for a breakdown of bitterness country okay click on summit that's it we have added our indicator rigid indicator and we should have to chart to area chart in the same widget so that's what we more [Music] okay as you can see here we have two areas are in the same widget one for active cases one for confirmed cases and if we select two countries we here we have the result for Austria if we select two countries it's going to pack brigade the result so you're gonna have the sum of those countries same thing for the total come from cases on the cover cases but in the level of the second row that you can see here all our column chart it's going to be separated so now we have to just repeat the same process to create our evolution of dead cases and recover cases okay so it's a new time series so evolution of recover versus active that's all right this is dead cases so I'm going to select your recover cases area chart the right label recover cases or break down country aggregate just pick a color click on submit that's it so we have our chart for record cases and we need to add one more vigilant Gator in the settings parameters here new dead cases put an order select a color give it a label and say it so it's the same process correct so we have done with the creation of the dashboard we have our dashboard we have the selection of countries we have a global situation report we have the country specific report we can change any countries see the result for the country that we want we are done so so hope you enjoy the entire series and have a good one