#Part 26 Create A Formula Indicator For The Mortality Rate
okay so in our previous video we have we have created total confirmed cases 50k total dead cases 50k okay there was the twin heaters and we have the result for few countries not for all countries now what we are going to do we are going to create a mortality rate indicator this is going to be a formula indicator we are going to use some existing in here okay so let's create our formula indicator now so under performance analytics you can find formula indicator so if you type here formula and you will get to the formal indicator okay click on that click on new so give it a name for your formula indicator so it's going to be mortality right for example the direction is going to be minimized that's what we want the unit is going to be percentage so it can change and the precision is going to be 2 and you have another section here the formula section exits this is variable we are going to put our formula so put some parentheses and browse for an indicator the first indicator we are browsing here is the mr. dead total dead cases 50k so type here total so you can get your the result so look for total dead cases 50k select that one divide so you put the divide sign browse for a second indicator and we are going to look for total confirmed cases 50k okay this is a basically up formula told these cases divided by total question cases in 200 okay multiplication 100 that's it we have our formula indicator created for the modality rate you can submit then reopen your motility rate indicator and then we are going to basically assign the breakdown yoke say for which breakdown we want to have the result so we have a breakdown already which is the country more than 50k cases okay so we are going to select that breakdown click on save and now if you scroll down once more and if you click on show in analytics hub in the related link you can find that one it will show you the result for the mortality rate here we go we have the motility rate this is a global mortality rate and you can see also for here by clicking on this sign the breakdown for all different countries so you can select any country one and then you see the result for that country that's it we are done with the motility rate thank you for watching
https://www.youtube.com/watch?v=S-WjhjgoejE