 Word of the Day is called DACA. So just to give you one minute to make sure you capture it. So start counting it down. So DACA, this is a Word of the Day. OK, great. So I just wanted to talk a little bit about legions. As I said, that in this map application, when you are drawing a map, we actually have what I can call a kind of region. The one that is being automatically created when you are actually presenting a map, but another is a region that is being customized, which is actually a fit-based when you know you are data, you have reviewed your data, and then you can put your custom region interval that if you are actually wanting to do analysis for one of the performing indicators. So you can just put the region in a way that it actually depicts what a user should receive. That for those locations or for those districts or whatever region that's have a high performance or have met the target should be given this color and those which are the actual struggling should also be given another color. And for those that are performing good, they are still at the baseline. They should be given a certain color so that should be able to differentiate which one has performed and which has not performed. I think this also you have already seen the way how to do that in the pivot table. You have already seen that how to do in a data visualizer. So for those kind of regions, they are actually being defined by the administrator after reviewing the data or after maybe given and required to request it to kind of define them and they can be used along to the intended indicator So take an example, for example, you can create a map, let's add one of the magic map and then we select the indicator group of the immunization. I can use one of the immunization coverage and I can take one of the example of maybe the BCG. Let's take this BCG coverage. And then for the period, let me take it for the last year. I can just put it for the last year. And for the organization, I can just want to show for the district. And then once I can just add it here, so as you can see, my map are being shown. But you can see this one, the region here, it's not now actually being integrated automatically. As you can see, things has been arranged in order. You can see that the laws is starting from maybe 0 to 70. And then we have two districts actually which is belonging to that. And then you have this middle, which is coming from 70 to 80. And they also have two districts belonging to that group. And then you have high from 80 to 90. And then the highest from 90 to 100. And then you have this invalid, those that actually goes beyond the range. But you don't have any districts that belong to that. So as you can see, this is one of the regions, our customized region that has been created after reviewing the indicator. And be able to create the region that we actually be able to categorize the performance depending on the location or depending on the organization. But another question that you could ask, but we haven't seen the place where we can select this customized region. So where does this come from? So when you are configuring whatever the indicator or whatever, especially the indicator, we have the place where we want to include customized region to that specific indicator. So you might find that this indicator, when it was being created, it has been assigned a customized region. So when you are drawing it or when you're analyzing the data, it will be automatically applied. But for those indicators that haven't been assigned the region, when they are being created, you can still assign them through any analytical tool that you will be using. So how to do that? So for example, I have this thematic layer showing it. So editing this one and then come to style here, first we are using this automatic color region, which is actually, if you take here, it actually provides the color code here where you can also decide to select one of the colors here. But for now, if you have this indicator being assigned the customized region during the customization, it actually picked this different. So the option to be that if you have the region being assigned to the indicator, if you want to use the automatic ladder, it will use those that customized region that has been assigned to the indicator. So as you can see, if you actually come to here and then you will be able to see the region that has been selected. So this is the one that has been created and then assigned to the indicator. But if it happens, maybe a certain indicator that was being created, it was not being assigned the region, then you could also be able to find the region that has been created that actually feeds to that particular indicator that you are analyzing. So that's how that's where you can also be able to select the pre-defined or pre-defined color region or the customized color region. But also another option, you can also show the labels. For example, you can also include the label. In fact, all you want to know are the performance of each district by name. So it will just give you, for example, this one here, which was highest, it was a vegetable. And then you have this one here, which was a dog and a different location that you can see. But again, you might also need it to see, for example, for this one, that is having it ready. For example, for the desert district, you might also need to know the facility that probably was contributing to the low performance. So how to do that then it comes to another functionality of drilling down or drilling up, depending on the level of the organization that you are. For example here, I can just drill down just by lightly clicking and then be given this menu, that whether I want to drill down to one level, or for example, if I want to preview the profile or showing the information, showing the latitude and the longitude, I can just click here. But here, for me, my intention is that I want to drill down to know the facility level, which actually maybe was contributing to this low performance in terms of BCG coverage. So if I click here, we just go ahead and then be able to show. So we found that although the entire district was having the red car, but we found that there are some other facilities actually they are doing actually not bad. So that is a few of them, but most of them they are doing actually they have low performance in terms of BCG coverage. So that's how you can be able to drill down to be able to see which facility maybe, which facilities are contributing to the low coverage to that district next level. So if again you wanted to drill up to the district where you are before, you just go to one of the first seat and then you like to click it and then you can drill up to one level. So clicking this one actually it will actually bring you to the district that where you were before. So that's how the way how you can do that. Although another way it could be like going through the entire process and then it may be selected specifically a specific maybe a specific district in the particular, for example, for example, go to the animal region and then a particular district and then update it. So here again it will give you the the the district to that particular region. But if you want again to drill to this facility, belong to this bed, a bed district, one way it would be that you can drill down by just clicking and then releasing this option. Or another way it could be easily go through the entire process, go to the bed here, come to the bed, and know where it may be to this one and then be able to. So here you now need to specify that I need it for the facility and then you update it. So updating it it will give you for the for the. So here actually sometimes might also be hard to know where this facility belongs. So you can decide to add the boundary layer that you just draw showing the boundary that of this facility. So you can just add that to one. So another idea is to go up where we are before and then you'll be able to see the bed, the bed, the bed district. So that shows the way how you can also drill down and drill up depending with the level of the of the reporting the organization that you are. So let me go to the original map that I was out there before another thing or another feature that could be used to you is that how can you know the underlying figure that brings to this map being displayed there. So another feature, how you can know the figure of each of these. The figure of each of each district, either by clicking to each of the district here, but the easiest way to be just come here to these three dots and you'll be able to see this menu here. So. Clicking up. You will be able to show. The. Hello, can you hear me? Yes, we can hear you. Yeah. OK, OK, great, great. I was struggling with the internet now. Thanks, it's back. So I was just showing you how you can know the underlying figure that this map has been a drone. So what I just said is that you will be seeing this for each layer. You have to be missing these three dots where upon opening these three dots here, you will see this menu here called showing data table. So creating it to it, you will be able to to be able to to see the value for each of the each of the district and the specified even the category whether it's high or low. For example, let me open one of the. Of the of the map. Or let me create one of the thematic layer, for example. Just quickly. Can you just open one of the thematic maybe HIV test performed? And then. Before doing that, let me just open up to set this thing. Let me open, which is called tools. Oh, I think this one here, for example. So when we just opened this map, which I started to to this page at the first time and then I could want to maybe to search maybe the facilities are having a data maybe greater than five maybe five, five thousands. So to do that, I can just come here for the show data table. And here I can just easily for the value we are being able to feed off. For example, if I want to show on those facilities, the five maybe five thousands records. Yeah, so as you can see here, I just defeated and it's just now showing only those facilities with only five thousands records. But also whatever condition that you can put, you can still be able to do that. For example, apart from showing maybe a facility with having a beta that is greater than five thousand. I can just put a range. For example, I can just want to show those facilities. That is actually having the data greater than the five thousand and less than it may be fifteen thousand. So how to do that? I just need to concatenate. Just add in there and then we specify. Maybe five hundreds, five thousands and put in this one. Less, less than maybe fifteen. So I can just do that one. So as you can see, I can just put some condition giving the range that I want. Those facilities or information that have the data which is greater than five hundred and then the greater than fifteen thousand. So that's how you can keep on a putting some range. And if you look clearly, it just gives you some of the some of the condition that you can use. Apart of that, I can just check maybe those who are a little bit maybe twenty thousand. Maybe if I do this, I found that there are two facilities we are actually having more than twenty records for the HIV testing from. So you can easily be able to do that and then be able to search even for the ranges that are there. So that's it for the data table, but another function that I might not be able to demonstrate here is that you can still, for example, be able to download the data, as I said. And when downloading the data, which means maybe work to use for other external tools like QGIS or probably maybe ArcGIS. So for those who are familiar with those one, if you click here to actually giving you the data that this it is supported, this is just so that you are downloading, you can use it for the QGIS software, including QGIS and ArcGIS desktop. So if you download it and then you upload to the QGIS, you will get the same map being drawn to another, to another external system. So before I continue to another session, I would like you to perform one of these exercises here to actually be able to produce what I actually done it here and then see if you can be able to filter or to filter data within the data, within the data table. So let me share my screen showing that exercise where I just give you just two minutes from now. So remember that the map that I just showed you you just saved it, remember from the previous session. So I would like you to load it and then be able to do some filtering where I would request you to filter those values which are more than 5,000 and then you can also filter those who are between 5,000 and the 15,000. So I just give you two minutes from now. Let me know if you are done. I would just be back here in the two minutes. So 16 minutes, 15 minutes, we should be back. Thank you and a good luck. Sorry to do that again. We didn't clearly hear you. Can you just come back for one second? Oh, yes, yes, I just asked you to open or to open the report that you saved it before that I asked you to serve which was shown the HIV test you performed. And after you have opened it, I want you to exercise on using the data, how to filter the facilities which is having more than 5,000 records. And also another filter will be like how many facilities is having more than, is running between more than 5,000 and then 15,000. Is that clear?