[Music] [Music] okay so this is going to be a big part where we are going to create our hopefully in the end we will have our dashboard with all our widgets not hopefully you're gonna have it and so we have to first understand different elements that we have in performance analytics we do have indicator source automated indicators a lot of other things like jobs breakdown picked on map pain so we need to understand that so first thing we are going to cover the theoretical part to understand better what's going on here and we are going later on we are going to create them so indicators or indicator source and use them in our budgets finally we visualize our result okay so it is bird that I give you the theoretical explanation in the beginning and we created and then we see the results so this is basically kind of the flow that I'm going to adopt now so I guess this is going to be better than showing you directly how to pay the indicator source and create a breakdown having and okay so in performance analytics we have what we call a mitigator source that's very simple it is a filtered data source okay we have our copy 19 cases table and on that table we can create an indicator source which is actually a filtered data set we want a specific error the community in cases has more than 15,000 cars but I don't want them out I mean I just need a few of them so what I can do is apply some conditions I can say here for example I want only fewer costs there of course it's only all the recourse created on daily basis for example today I don't want it created two months ago and also the confirmed cases should be more than zero okay these are the two conditions are important and this is the specific indicator so stir to create okay and it should be create this one the indicator Seoul should be generated on a certain frequency and it will be done on a day frequency okay that's why I have the frequency here so these are the things that we have to mention when you actually create your any key resource I'm going to mention which table what is the frequency what is the condition the second one is the Automator indicates the automated indicators they are the ones which is going to actually will help you to calculate some specific results such as the total number of dead cases or confirmed cases or recovered cases so we can use for that I mean automated indicators so in our case we are going to create one or many but we are going to create automated indicators which is actually going to some for example the total number of death or the number of the curve cases so we'll be using that function and then on which fields so we are mentioning for which field you should calculate so it's going to be the recovered field and also mentioning we should also mention what is the frequency on which frequency you should go to your indicator source and calculate these numbers and return the result okay so the frequency that you have to mention and it is a highly important to have the same frequency for both of them okay indicator source you have daily and automated indicator you should have also daily if you want to use if you want to apply if you want to use this automated in here for this indicator source okay that's it so let's create our indicator source and then our automated indicators so we can have the result for the total number of death of number of recovered number of confirmed I mean the global result [Music]