okay so in this part we are going to create another indicator which is going to be total active cases so how we can have the dual activities we do have already three other indicator okay so indicator indicators right so we have function cases we have record cases we have dead cases so the active cases is basically a calculation that we do by using other other indicators so we're going to take the total confirm cases - that - recover it is going to give us the number of active cases so the first part here is to write a script which is actually going to return that specific result so let's write our script in performance analytics so under performance and Isak module you have a script here so just click on script and then click on new so we are going to write our script so new the title in the facts table it's going to be come in 19 cases table and we are going to mention here which fields that will be going to use so to confirm recover and that and we are going to write our script here so the first thing here I'm defining the function so the name of the function is active which will have three different arguments X Y Z and I'm going to calculate by saying return X minus y minus Z so we will get the result in this way now we are calling the function so active parenthesis and we gave the first parameter it's going to be total confirm so current dot total underscore confirm so that will be our X and the rest we do this we do exactly the same thing so current dot total underscore debt and current our Turin school recover so this will be our why and said so that's it for our script very simple one so click on submit so now we are going to create our indicator so look for indicator click on new so I'm going to give a title it's going to be told active cases for example [Music] the direction is going to be minimized in it I'm gonna select that one precision one indicator source is the one that we have faded in the beginning total of today's coffee nineteen summary I input aggregate sum and you select scripted and we select here our script Cove in nineteen active cases strips great we have done with our you know total active case indicator so we can we can add now the breakdown so we have one breakdown which is our country breakdown so I'm gonna add that moon [Music] [Music] perfect now we are going to add our indicator in our job so we do have to job okay we will start with the collection data collection global so I can see here there are three indicators we're gonna add the fourth one which is the total active cases [Music] so make sure here for total item cases you have no breakdown okay this is a global result so we don't want any breakdown here so you can execute the job now okay we are done with the job let's so let's look at the result now so let's pick the total active cases indicator and see the result in the score sheet click on the later link here scores for this indicator and you can see all the reserved for for all countries thank you for watching