#Part 20 Theoretical Explanation For Breakdown Breakdown Source and Breakdown Mapping
[Music] [Music] okay so so far what we have done we have created our indicator source indicators our job we saw the results in a skosh a and we have the global result okay the total sum of total debt recovered total confirmed cases and we have the global global reason now how we can have the result for all countries okay for any all countries so for that what we have to do is to create a breakdown and in our case we are going to create a breakdown country breakdown the most important part when you create a breakdown is the breakdown source that's where that's where you get the breakdown actually okay when you create a breakdown you don't put there is not too much parameters there you just have the name you give the name for your breakdown and then you mainly focus on on your breakdown source which table you are using or it's a condition and so on so we are going to use you know in our case here the breakdown source it will be the coal country table so it will return us the list of all countries but I will put some other conditions such as the total confirmed cases will be more than zero should be more than zero okay we can have a related list condition as well when we will see that so in summary here the breakdown is the list of the countries okay that we have and our result whatever the result that we have total confirm total dead or recovered we should break it down with the breakdown that we have here so the country so this is my Scotia okay this is like the score sheet let's say you're building disco manually so we can understand why we need a breakdown mapping that's second thing right we need a breakdown mapping and why we need a breakdown mapping and we if we understand how the scoresheet is built we can try to guess oh this this is the reason why we need a breakdown here I have for example the country so all the countries and then I have an example total debt here as a result it can be anything recovered so the country that we have here this is this is the breakdown which is like is taking from the breakdown soils here from this part okay these are breakdown records that we have here and it is taking from here so we have naturally I'd say the sis ID of the countries here okay but the score sheet when you are building if you have the Society of the countries how do we know which number we should put here we have totaled that how we can make the relation how will you know that Afghanistan will have the result okay so how we can get the number the way we get the number by creating a breakdown mapping okay we create a breakdown mapping we are saying hey this is the breakdown source I have the list of the countries so you can have the Society of all countries so use the society in the indicated source so I go it goes to the indicator source and we have to say hey this society should be the value of one of the field that you have in their indicator source so in our indicator source we have our location field which will refer to that specific country so once we have once we have the society and we have right in the indicator souls for the vacation field and we know for which result we should get doing total total debt total confirm total recover and we can get any of them by knowing which indicators that we are using so if you're using the indicator total that it will go and get the result of total debt okay so we are taking the sis ID here and mapping it to the field that we have in the indicator source this is how we are building the score sheet so if we have understood that we can use I can create different breakdown okay so this is how I understand here how it works so let's now create our breakdown breakdown source do a breakdown mapping and see the result in a score sheet in a real one
https://www.youtube.com/watch?v=QbiJiuWTkmg