okay so in this part we are going to create our mortality rate okay the mortality rate for countries where we have more than 50,000 cases cases so how we can do that the first thing we have to create a breakdown source where we will have only these lists of countries only countries where we have 50,000 trees then we have to create two different indicators okay in the one indicator which will return the total number of confirmed cases for these specific countries and then one other one other indicator total dead cases okay so once you have this result we can create a formula indicator which is actually going to use these indicators and calculate the percentage but first let's begin to create our breakdown source breakdown breakdown mapping our jobs in order to get the result of our indicators then we will go to we'll be creating our formula indicator for the mortality rate okay let's begin that so first thing is our breakdown source so look for breakdown source click on new so let's give it a title here for example country more than 50k cases breakdown source [Music] okay the facts table is going to be the core country table and the field is going to be the sis ID and in the related list condition I will select the table for example cover 19 cases location and then select the field or confirm it should be more than 50,000 cases so this is how we can get that specific list of country so if you click on preview it's going to give you only few numbers of the cards you can see here tour through your cards click on submit we have our breakdown source now let's create our breakdown okay so let's give it a name for our breakdown here so the breakdown source is the one that we have created previously so more country more than 50 K cases breakdown source click on summit we have done a breakdown but we have to assign here create here the breakdown mapping okay click on here on the related list will get on my Fame and choose your fact table which is going to be in 19 cases and then the location field right so we have done with our breakdown source breakdowns and breakdown mapping now let's create our indicators so we have two the first one is total confirmed cases let's say and then total that I'm going to give a name here for example total confirmed cases 50k [Music] okay the direction is going to be minimized but you need here I'm selecting that one precision one indicator source it's going to be the same thing so the one that we have created in the beginning today is Covey 19 summary so aggregator is going to be a sum and it's going to return confirmed cases totally fine okay so you can't submit okay let's create now our total dead cases so the direction is also minimized same information that we have selected for the previous indicator the same indicator source and it's going here we're gonna have a great song and the field is going to be dead some night we have created our indicators now we have to assign the breakdown okay these ones will have a specific breakdown the breakdown that we have created right so let's do that so I am selecting here total confirmed cases [Music] so click on edit in the breakdown tab and look for country more than 50 cases breakdown okay we do the same for our total debt total debt cases with dk okay so we are pretty much done with the indicators as well so now is the time to create our a job so we are going to create a new job we have already two jobs for data collection global and data collection for all countries so this one is going to be only for for these specific countries where we have more than 50,000 cases so I'm going to give a title here for example pa Kobe 19 data collection 50k okay it will relate the starts the related start is going to be six months ago and related and zero days ago Los Angeles Times on 8 a.m. right so now we have to add our indicators so let's add two of these so total total confirmed cases and toadette cases for decay for example here that's it you don't need others and then we can execute now okay so we are done with the job selected so we can go look for the indicator and pick one of them and see the Scotia as you can see here we have the result of total confirmed cases only for these specific countries great thanks for watching