 First of all, I hope these other steps are clear on how you should select all these parameters. I'll just randomly pick any data, not exactly the ones that we have in the question. So this is more or less what you have once you have selected all the parameters. So to be able to include the legend, you have to go and tap this options button. If you click that, under it there is legend. So you need to go to legend, select that, then tell the system to use the legends. Once you have ticked that, you'll have these other options in terms of legend style and legend type. The style is more or less on how the color coding should be embedded into the table. So it's whether background color or text color. So by default its background, I leave it as it is, then select the legend type. The system supports two types of legend, whether one which is directly attached to the indicator, and this is done when you're configuring this indicator, or the other one is to pick a single legend for the entire visualization. And this is more or less to select on the available legends. So since it's HIV, we're going to do the HIV test positivity rate, the legend. Then once you have selected that, you would also wish to see the key. You could also take it. Once you click update, then you have the legends in your table. I hope that is clear. Is that or do you still have issues? Yes, this is how we did it during the class. But if we look at the question in questions five, the example, that is not. The legend on the right here was attached to the table separately. Any other facilitator who at least understands what is the concern? Because I'm very difficult to understand. I think we want to say that you want to try to position the position of the legend together with the table. Is that right? The position of the legend. You cannot position a legend because it's not a parameter that you select, but rather you're asking your data to be color coded with whatever ranges that you have configured in the system. So it's not something you can position like the way we could take and say I need organization unit in filter or periods in rows or columns. Okay. Thank you. But I think we need to look at the question for number five and see the tables. There were the table number in the second table. That's where I'm speaking of. Here we have question five. Let's go up. Okay. Yeah. Yeah. Yeah. The first table on a question five. This one. Okay. Yes. This is not supposed to be part on what you are doing. This is just a snapshot of telling you what are the colors and the definition of the legends. Okay. Thank you. Now I understand. Thank you. Yeah. Yeah. Yeah. All right. Hello. Any other questions? Yeah. Hello. Yes. Hi, Mr. Yeah. Okay. Thank you very much, Khadija. I think the presentation yesterday was very good. I only had one difficulty saving the table as favorite. Okay. So first of all, when you speak of favorite, let's all clear our minds that we no longer have a tab named favorite in DHS2. I understand that was part of the previous people table app, but it's no longer available into this new data visualizer app. So you won't find a tab specifically named as favorite, but rather you just be saving a table just like the way you save other files. It would be an Excel file or a Word document. So how to save it? You just once you have created the table, you go to find and click save. So you just save it as it is. We don't have a very specific tab or button named favorite. Thank you very much. I think that is okay. I think that was my confusion because I was looking for the tab favorite. I could not see it. Now I've understood. Thank you very much. All right. Welcome. Any other last question? All right. So if there are no more questions, I would like to hand it over to Prosper. Over to you, Prosper. Oh, yes. Yeah. Thank you very much. Tim Rwanda, and I hope I'm loud and clear. Apologies if there is a kind of an apple, I'm trying to find a situation where it will not be doubted by anything. So again, I want to welcome all the participants to their file. Their file is almost halfway done, which means that at this point, we should be really getting most of the concept as far as analytics tools are concerned. So there we are going to look at again visualization of data. And this is a continuation of where we are left yesterday. And particularly for today, we're going to be looking at the visualization component of charts. And we're going to talk about the charts. What comes into your mind is, you know, the bar graphs, the pie charts, another type of view that we try to be able to see today. There are quite too many. And then just to give you highlights of the charts, one is when you're working with charts, most of the time is limited to how much data you can put into these charts. So it's not like the pivot tables where you can even throw in over 100 data elements, indicators and all that. We visualize that if you're going to make meaningful and usable visuals, you are likely going to be talking about two or three or four. If there is a chart that goes beyond that, I think that is just a data quality chart as opposed to the data visualization chart. The other thing is different from the pivot tables, you are dealing with filters, columns, rows. Here we're going to be dealing with quite a number of other layouts, as we shall see. Each chart, different charts have different layouts. So we need to be very keen on that and see when the layouts change. And again, there's a lot that changes as you change your layout, why, where you place the data, where you place the organization needs and also the pivot. So particularly in this session, the objectives basically are to really introduce you. And I know some of you may have used these charts before, introduced you to the dimensions, how to deal with the dimensions. Again, we will see that in this chart we will have more dimensions coming in, depending on the different charts that we shall be selecting. How to modify the layout for each particular type of chart. Saving is what you're going through and then of course also dealing with different charts, then finally how to download and then be able to use them as we prepare for our dashboards. Secondly, we will also look at all these types of charts from column charts all the way to scatter plots. There are quite many and I hope given the time, we will be able to see each of these in today's session. So with this, I think we are ready to get into our session. And again, as an online training, the team, the academy team has managed to prepare for you a clear step-by-step guide that I think you should have been able to access through the learning portal. So you should have been able to access this from the Mudo online Mudo. And once you go to the file of the visualizer, you will see charts. Of course, you have the introduction slide that I've just gone through and most importantly of this guide. I would encourage you to resist from following it as we go so that you pay attention and rather use it as something to recap and also be able to understand more after this. Otherwise, if you're going to go side by side by me, grading and going via this, I think we may a little bit get lost. So let's all be able to follow as I try to demonstrate. Again, I will take, you know, the throatness so that we can be able to go step-by-step. And in this session, we're going to deal with quite a number of ways of starting to do these charts. A majority of them, we shall start from what has already been created and served one of the books which was asking for parents, but there are some charts which have been served for this purposefulization. So we will be able to use some of those. But again, also for emphasis and trying to allow you to be able to see some of these projects and how they're some of them will be for the purposes of showing the step-by-step diet. Again, for the purposes of the training, we are going to use this academic demo, which you don't have access to this one, but you have a similar copy. But again, you should be able to go ahead and use for purposes of revision and also be able to recap on some of the concepts in this. Again, also I do encourage that if you don't have the facilities to be able to move along with the instructor, you couldn't be able to step-by-step be able to follow and then try to create it alone. Otherwise, if you're going to use the same screen as to the one you are viewing by demo, you are likely going to get lost. So if you have a projector or your extended computer screen, you can use one for your practice as you move step-by-step and then also be allowed to follow it up if you've got something. So already, as I have shown you from the dashboard here, which again, we shall be able to start creating next week, you could already see some of the charts and these are going to become familiar when we start creating them. So the purpose of us doing this is for you and for us to be able to have a dashboard or to have presentation that you can share in the report or presentation that you can share in the report presentation. So some of these charts have been created, charts and people table as you see in here and probably even the maps that have come have been created by these analytic tools. We've had a lot of improvements as we shared at the start of this academy. There have been quite a lot of improvements in terms of these charts. You will see new chart types, you will see new handling, some of us talking about legends in charts and all that and we should be able to all use this again. So to start this, I will start with our activity number one. The activity number one is really appreciating the charts that have been created before to be able to start looking at how charts behave and also to be able to highlight the dimensions and how that is treated or presented when we change the layout. So for us to be able to get to the the better visualizer, again we have to go to the apps, the apps main and shortcut and then we will put the better visualizer. Again, this is not given. We've seen some being implementers, some these some companies where they have only given you access to few charts which have only been created for, they don't give you access to create your own charts. So we have the data visualizer app that you can search for here visualizer and this is the one you're using better visualizer which combines both pivot table and the charts. Again, also you can also be able to get quickly to the data visualizer by looking at any of these charts or pivot tables. They are three dots here in the corner of each chart that has been created by data visualizer. When you click on it you have these different options to do it as a table or a map but it's opening it and into a better visualizer. So you could start from a chart and when you open it opens and then you can start with that. There you can go and make and clear the charts and then start clear that particular chart and start over with creating your new chart. So let's go the traditional way of going to applications, site or filter by visualizer and then you click the dot. I hope we are all together for those ones for a long time. You follow at your own risk. Otherwise I try to take a slow space so that we can be able to go through so this is our better visualizer layout. Again, not much has changed and the data was able to explain the different components here. But when we load it, most important thing that we see here is our dimensions that we will be dealing with and are going to explain those little details. Of course adding to what has come from the table tables. We have options up here in terms of managing our charts and how to be able to save them. We have also an area here where we move around the layout. This has changed it from the different versions. The different versions who had it as a menu here but now it's just here. You keep dragging and dropping and then we have recently almost viewed charts which will also appear here. So you could also be able to open the chart that was recently used by creating here. So let's go to our chart number one to just be able to start from the chart that has been created by us and again we are training you to be able to create charts for a lot. They are probably not going to be able to have access to the visualizer or they are not going to be trained enough to create their own charts. So you will be saving them as a winner who will take you through how to save these charts and then you can be able to allow people to view them. Again we shall also be able to see if time allows how you can also be able to see access of these charts. So from the file again this is carrying on and trying to make these charts a little bit more user friendly. I know most of us have been able to thank you so much. Okay can you hear me okay now? Sorry the sound is so loud. Okay let me try to speak louder. I hope I'm clear now. From my side you were clear already so I don't know maybe it is an individual issue. Same here you're loud and clear. Okay good thank you. I will try to keep my mouse in the computer so that I can be able to not lose anybody but if I'm over shouting on your side please reduce your volume. Okay yeah so we have one throughput one of the starting charts that we do for throughput is somebody was able to create for us a chart and this is a bad chart a problem chart so I will go to file and go to open. So just like the way it is for your Microsoft office you go to word open and this is how it's been trying to try the details to is trying to make this very easier and user friendly just like any other package is that most of us have told ourselves open file save file save as we name and all that or even open new. So I'm going to open and when I click on open I will see all the charts that have been given access. So this is a list of so many of them you may just go through pages and pages but we have a search here that allows you to search for any chart that you want you can search by the name you can search by the type or you can search by a person who created by a person so you just click on created by me or others and all that. So let's look for a chart that has been created on HIV trying to show us the cascade you know like the HIV testing starting on treatment part and the contribution with the care so it has been saved as HIV that is the prefix that they have used again we do encourage that you prefix your charts here one thing that we have got introduced in here is the option for saving under folders you know like in our course of the warden office we we save under folders and that's something I think we have been raising to come so that we can be able to be able to separate our work our charts so that they are arranged like in kind of folder format but right now we're doing kind of matrix whatever charts you're going to using so it's HIV cascade so I can keep typing the browse down the search and this is it again I have realized that this is probably not the right this is probably a small bad most times when you are hovering over something you want open it either brings the hand and allows you to click and open but if you realize that this is not really the best way so I've already picked up this and it should be something for improvement but at least we should have a way to show that I am clicking open so when you click it opens and runs for you the chart so the chart is going to be loaded and again this is like magic happening so I've not been able to create this chart myself and so somebody created it and I'm able to open and use it now depending on the rights that have been given I can modify this chart and be able to save it overwrite it or save it as a new one as we shall see again so in this chart you will see that we have different data dimensions that we are looking at we are having a chart that is showing us the buzz of HIV testing those who tested positive we have a chart that is showing that I mean that showing us a bad that is showing us what you want at means that if they tested positive they must have set it on ART on the antideviral treatment and then those who are tamed in care in the last 30 months in the last 30 months so for those who are from the HIV world this is where you want to make sure that everybody is tested positive you start the treatment and then under 12 months you all have the treatment that is the objective so if you want to be able to show this kind of you know like close follow-up and you know the efficiency of your interventions this is the kind of chart that you'll be able to do and again for other sectors TB, HIV, malaria this is a kind of a chart that probably you sometimes start with in the education you want in law and then you promote it and all that so there will be there will be similar use cases on how you can be able to use this type of chart but what I wanted to really show you here is how the data is presented um this being a column chart and the and the bar chart again you will see we're going to be dealing with series category and filters for now but again as we go through our chart different types of charts you will see these you know dimensions for layout change so at this point you can be able to even see that you know organizations have been putting the series that is really showing what that is in here so all the data from the different health facilities are being aggregated and it's being shown as series then in the filter we shall talk more about the filter is showing in the last 12 months and again when you hover over in on this you will be able to see the kind of selection that is there like for example it is already showing us that the period that has been selected is last 12 months when I hover over data it is getting that there are three elements and those three elements that have been selected are just there organization units it is just the user organization the youth development i'm assigned to so um again you will see that this chart you can change the layout in any way you want you can move around whatever you want to put in the filter or categories and so on um the one thing that we won't start with is the filter this kind of the filter sometimes will serve different many purposes one is to show you where the data is coming from like what we are seeing here it is showing us the data is coming from 12 months and all of them have been aggregated and uh and this you will see that when I use the filter when I change the filter which is now the period changing it probably will look more less for less period or less month the data will also be reducing according to that for example if I just say I want to change this I can be able to click here and change my selection or I can go over this side and change my period from here so each of the other ways is now I think I will be able to get your your selection done so let's take an example like if we add this of three months and then somebody comes and says I want it for six months so what do I do do I have to trash this and go back to you and say click new and then we do it no I can just come and only change in a period by clicking here then I will get that menu and it allows me to remove this just either double click or click only and send it back and then go to six months and click and you select it and update so what you will see you will see the data has now released from 100 plus what we had for each I tested the six months which shows you that you know the filter here is trying to filter your data downwards through the what you are able to select if you bring it to here then it will be able to filter it and and and make it more uh more value values presented into the chart um you can also modify the layout for example I can say you know like right now if you put on additional charts this is the y-axis this is the x-axis and for now the x-axis is being implemented by the category so this is categorizing how what that I want to show from the x-axis and the y-axis showing them the same the the um the settings for now so um if I move and if I want to move this to switch to this I just um be able to just move and drag around so for example I can just say I want my period to come to the categories because I want to see them down here on the filter and maybe now now my data can just can go up to um categories then say sorry and then I put the organization here so I've turned it around 160 or 360 trying to say that I want to see my period here so I can I want to see my data here down here not where it is like this I want the data here at the x-axis and then I want the periods up in the in the settings so I update so I can change all this and then I'm able to affect it I'm able to update and this is how I've changed my my my my chart so basically what it's doing here is allowing me to be able to analyze all the months for each particular um uh better elements so for example HIV I can be able to see this much as I'm doing a comparison to see my cascade over time I am being able to compare within the watch within each other set and that's where the series will come in as being the period so I can just see the different series which now is going to be the different months so that's the other way you can also be able to change the chart and here again it can make it makes meaning the internal analysis or want to be able to see the overall um change over the different data elements but also you want also to be able to see the change within each data element okay so for some of you I'm asking question right now I'll come back to us later on um let's continue and see I can I see changing colors for the rest of the day okay so that was a in terms of changing um they could also be able to see I want to see a cascade so I see for uh each period I want to see how it goes so I am I'm going to be able to compare data across the x axis for for each period I say for September I want to see how the cascade was for October I want to see how the cascade was so for some of you I've been careful and following very clearly you will now be able to see what I'm able to change to be able to achieve that so I want to be able to see um for a given month what has been changed what has been the the comparison what's the comparison between the three data elements so that's simply by making this a series compare the series and then you can compare down to the category and update again so you will see again I'm achieving my objective of being able to analyze for each month how the data has been changing go they compared in the three data elements for indicators for each month but now my trend is is there but it's not really the cascade that is showing the difference between the data so I'm now being able to compare that for the three data elements for indicators for each month so again um this is uh how you can be around with column charts and also dealing with the layout okay so again let me take some time to really explain um uh some of these charts here uh the layout itself the filters the series and so that we can be able to now dive into the next step when we are all aware of what we are looking out here so um I think I have said that um what appears in the series for the column map is what will be compared within the chart itself so if I put video here that's what will appear in here so if I put when I let you know that's what's going to appear in here so for the series for this column chart just take it that whatever you put here is the comparison if it's one data element that comes selected say for example it was one removed here it is going to be able to show on the one so this is this is great for the series for the categories for the column charts that we can take it all the all that you put here will be what appears for the x axis and then the filter is just the way to um to show where the data is coming from and behind most of the times it's going to allow you to do the application for example if I put all the districts here they are not going to show anywhere if I put all the districts in our training land they are not going to show anywhere they will all be updated and then filtered and you see the same one the same layout so that's basically our first exercise that was going to allow us to be able to look at certain charts and also be able to look at how we can be able to manage the the layout so I will stop here and quickly look at any questions which in today's event that relates to this um I there is a thank you very much for explaining some we will be able to come to that and this is something that is looking out here because with the cascade that's okay so we go to the next step um the next step is about saving saving this chart now the name I opened this chart from what was what has been saved so should I want to save this chart as my own if I save it now it will override what the other person has saved but I may want to use now this layout I have not done much what I've done is play around with the layout but it looks very good for me and I feel like I want to be able to compare this and you know every month I want to compare my different data elements so this is a nice chart I want to see so to be able to save it just go to five click on five and click on save us now if you can save it is going to override the other chart and sometimes you'll find that you don't even have right you may have right to you and this save will be great doubt so I click at save us and then I will erase what is there again uh and then I can say this is my chart uh HIV cascade so again we are encouraging you since we don't have folders and management file proper file management file here always do some prefix and you know try to explain what the chart shows but if I even look at the chart it may be said I can do okay what it has and how it's how what is it it's it's storing without even opening it so we do encourage that you you can even put a description so I'm going to move this to the description just put a description for your chart but make sure that in your chart you are able to specify if it's a domain if it's a domain or a health program please put your health program like for example this is HIV and uh try a little bit explain what it has and the what that it's collecting and what period it has now putting last 12 months not you know not september 2021 to 22 February because this is a chart that is going to be moving time it's the period is relative otherwise next month this month will be dropped and we can have a pass so I save my chart that is as simple as that now I have a chart here so if I go to file open and I look for opening and I now for HIV cascade sorry HIV cascade I should be able to see some two one which was originally there and the one that I save which is this one here and I can open so that is how we save the uh the chart okay so um again to help us to really get to this type of chart I'm going to go through uh explain to you the layout of this um of this of this uh uh visualizer and particularly in the concept of the the charts I know uh I did the same for to you in terms of explaining the layout this four window uh in relation to the pivot tables so what I'm going to do is to explain this layout as we relate to dealing with charts so to start with uh I will start with the where we choose the dimensions we choose what we want to be able to show in our charts and then we start with the drop down list here which shows us the different types of charts that we have and again given the time we should be able to go through all this um today we have the column chart which is default yesterday you look at the pivot tables and then we don't we're not going to touch them again but we look at all these types of charts you have the column, column, column chart you have the stock column chart, column chart, line graph, area chart, stock area chart, up this catapult chart as we shall see today so this is where you choose the type of chart that you want to be able to uh visualize for example I may want to have a line a line a line graph and the line graph again it is going to be used for comparison we'll just always know that with line graph you want to kind of see your tray so I just click on it again this is not casting it's done you can come back and be able to change whatever you want and at the time we change the we change the type the chart type here on the line graph and your update you will be able to see that it now changes from that type to the type that we want then um we have let me just start with a new one just just to be clear that we are all starting from the fresh uh the fresh table so you will come here and choose the type of chart that you want now for example we are given um we are given a task to show the trend of keeping notifications over over time in our in our data and now switching to keeping given option is where you just find out how many people have between 14 and 25 have tb so somebody is interested in showing that trend over time like say for the last 12 months what has been our tb in education rate so you will have to come and click on one a line graph then the other three main main dimensions that we select from here again as you you did see from the as you did see from the from the view tables these are mandatory dimensions that we must select when you're going to do the visualizer we must select the data we must select the period and we must select the information knowledge those are the three core dimensions of the ghis and again down here we have categories so we'll also be talking a little bit about how that data can be categorized for example male and female under five over five so instead of you going to find out what category that that data element has or if it has we just just we can say give me the assigned category then we will have all the different dimensions that we have strictly selected into your chat and this will depend on the data element that we've selected and you will be seeing some of them have been meaning that their community can use it for that otherwise these ones which are not so the data element that I've selected they are not going to be used so I'm going to look at the tb notifications so I will need to choose the data so I come and click here and here again there is a slight change so most of you must have noticed this that our search now comes first and everything including data elements indicators that the program indicators all that will be in this list and you can start right away by searching for what you want like for example I want tb notifications so it's tb dash tb notification so I am searching it's going to give me a list down of all the tb notifications now I can also narrow down if they have come so many I say I'm only interested in the indicators maybe I'm only interested in the indicators or I'm only interested in the data elements you see that there's no data element that it has tb notification so it's data element so I can also be able to narrow it down and I can also be narrowing down to my groups say I only want tb maybe that is tb notification because that's where it is but if I choose a different group at HIV of course those indicators are not there so the filter is now can be narrowed down so this is in tb notification but again if I don't know it I just say selecting all groups so I want to look at the trend of these notifications over time per thousand, per new notifications, read-ups and all that so I add all these ones there by either selecting pushing all of them or they go because they are only three indicators I'm interested in so I push all of them there and I can be able to continue that I can either say update but when I say update it will take the default of all the other selections that are there but it's just hide for now we've done our selection so we just hide and we'll finish selecting our data so in here if I do an update already there are four elements that have been selected that you see them here and for the period you see it's on the one which is saying last year but for this somebody was interested in looking at the trend from 20 it's a port tb that is collected quarterly in this system so you have also to go back and look at your data analysis so tb is selected quarterly so I will go to the period and then I can either use this or use that to select my period now it is shown me last year but somebody says you want to see a quarterly trend from 2018 to 2020 so if I go to quote a relative period and I go to quotas I am not going to be able to get that that 2020 2018 quotas or the way to 2020 so I will not be now using the relative period because they have specified exactly the period they want to look at so I'll just come in and go fixed periods and I choose quote that's the letter that I want to look at and now the quota as of the quotas I want is I will start with 2018 we'll scroll down and go up 2018 so I want all that in our 2020 2019 and 2020 so that's the trend the kind of trend the team or the person is interested in you want to see the notifications over time and in the line cloud so you can either update or hide and when I do that I still you can see I've seen all my selection right here and lastly is the organization unit the organization unit is that you want to see it for the whole country so if I click here or click there I should be able to see that it's the whole training land which has been selected again we shall be able to see how you can see lower levels and all that but this is what we're interested in so we keep watch the training land and again I can hide so my my table is my chart is ready to be displayed and so I can be able to say update and when I update that is the kind of trend and what here you can be able to see for all the notifications I have been able to show my the personal work basis for this data the trend over time for those from 2019 quota to the 2020 report so this is how you can start from from fresh and be able to be able to look at your chart and here particularly we were looking at the line what the line is so this is a better analysis and and again many people can come and say maybe I don't like this the way it's around here I would have wanted to see everything in the in the series all the data in this all the all the period in the series just push it up there and then maybe the data into the category is going to come down here and update now look at what we have here does this really show any meaningful analysis maybe maybe not but you know you can connect to those the different items yeah so the line graph can show me the maybe the line of graphs I could get rid of the line of graphs and probably make a bad form chart that could give me some kind of analysis like I'm going to analyze each tb notification but yeah but when I have this which is showing the kind of trend that they download the best category is not really much but also it depends on the data elements that you are using if really it was for the first case that we had it would still make sense that you are able to see that you know there is a download trend but you can also be able to analyze each in a in each uh okay so that was to do with line graphs I wanted back where it was but let's see if I want to change this the but a but a column chart I can come here like I said in the column chart and update maybe this can give some really meaningful for within each application we able to see the trend for the application of course okay so that was to get us also to be able to select our different dimensions move them along but still dealing with the column the bar charts which have the same layout in terms of the x axis and the y axis axis being for category and y axis being forward for this what I say okay um let's move on next to probably one of the other and have a break and take a few questions here let's move to looking at stacked charts how we deal with stacked charts how we stack data we need a column basically which is also good for comparing uh problems overall problems but also comparing data within a given categorization for example we want to put you know um patients in load for whatever program but we want to be able to in each bar to show of those how many are male how many are different categories so third person group at this um I was I was just not saying if you wanted to keep this same again you remember our saving you go here click on save now you see it's not save us because I started from the fresh uh page and I started creating this one so I'm not using an already existing chart so the only option I have now is to be able to save this but let's just uh not save it and and the goals try to look at one of the charts that has been created for us to be able to understand the uh the stack it how we stack the different uh charts so again we go to file and click on open and this time around again um this is keeping the last filter so you can read it or cancel it here and then you type in your new filter now I'm looking for a chart called HIV HIV tests performed by quality test performed by quality which is this one here so I click on it and I open so this chart and um and and see how it really displays first it is stuck to a hundred it's kept a hundred um a hundred percent but within a hundred these numbers are not adding to a hundred so basically what this chart is trying to do is try to help us equalize all the the bars uh as you as you can see that when I have them of different names I am not able to easily visualize uh these these different numbers for example if I if it was going to be total identity what comes on top some of the bars would be higher and some of the work and so we shall see starting to a hundred for the purposes of allowing your easy visualization you see now this is very easy to to see upslang in terms of so this is this performance and this is a clinic is going out to do some testing so some testing is important at the primary health care other than dispensary at the health center so I can quickly be able to realize and see uh they're more ready so we are doing a lot of testing at the health center across all the districts because these are the different districts while it is limited testing at the dispensary quickly but if we had them not stuck to a hundred or um um put to a hundred scale it would be very difficult to tell the difference but this is already pulling it a little bit out to be able to tell us quickly but just bear looking like it so this is a chart that I'm going to go step by step to create so that we can all be able to see how we can achieve this so to do this I have to know which dimensions I'm going to work with for example I see things like these spits or these spits I see things like the dispensary I see things like last three months so all the regions that I want so it's basically somebody asked me and say please give me a chart that compares testing across different facility types for all the districts for this given period of time that's basically what they're going to carry and then you will now go and struggle and say okay how do I do this and what so I'm going to crush this just by looking at a new one so I have nothing in the same memory and I'm going to start so we have seen that what we want to create is a stacked column chart but come to the option here and I choose the column chart that's step number one okay step number two is to choose the data that is required for this chart and as we have seen we wanted to look at tests performed HIV tests performed that's the data element that we are using is a data element it's what I'm going to create so I come to data here oh you will come here and I select tests for okay so you realize that now I have two of them and one of them is an indicator where you see this sign here this is for indicator and where you see a dot that again this is something that has been to this that's new because we are bringing everything together all the indicators we don't necessarily going to start selecting I want an indicator one data element and so that's something that can come also here so I want a data element but if I say that I can be able to go back and say please save from data elements so I will have that as I click and again I can either hide or update let's hide for now and I will see my one data element has been selected the next step is to select the period so the period you remember if you remember our chart our production should have left it's open so that you can get it open and you guys see this I will run it in two windows not to confuse you but just have a window where I go to be a compiler so I open it towards hiv tests by quality by quality okay so I'll keep doing this so um I have selected my data element and now I need the period the period was last 12 months so yeah it's showing last year so I move this and I can click now relative to the last 12 months so you double click and then it's added again you can just say you can just hide or update sorry my period is selected and the organization image if you remember from our chart here so from our chart here we are supposed to have all the distance so how do I select all the distance I'll come in here to my chart here and I will select all the distance so I can either select from here or set from here by clicking on the one all the distance so all the distance I have and click that and maybe go in and select one by one by one but we have also we have also a way to be able to stand at the level and select all the levels all the lower levels at once for example I want to select within the training line give me all the distance so we have options here to allow us to select the level and also allow us to select the given group so when I'm at the level here the level of the distance is at least so I want to be able to come here and show me all the distance in there be able to pick this simple selection will automatically save for me all the distance will be all the distance given to my chart and again I can be able to hide or update so I have all my distance I'm retaining it the training line is selected but under here I'm setting the level of the distance so I'm basically done with all my selections and now I want to see my chart so I can update and basically this is how the chart is going to show so remember it was last 12 months which is here for the district training line for this data development but again it's not achieving what the person wanted he was first of all wanted to compare for each district for each district he wanted to be able to compare everything so that means we need to make our layout change in a way that we can do with how these districts appear here so what do we do if you remember from our home and line graphs this is always our x-axis the category is always our x-axis so that means that I need to move you click and I need to move with this one here and probably take this one into the field and again I update so what you will see you will see all the districts appear here with all the HIV performance for each of the districts from the last 12 months okay but the first one here he was interested in um ensuring stacking by um by facility type by type of facility so that would mean that we need to get into our chart and look for the dimension that is going to subdivide our data into the flow of facility type so we have a type here of facility so you can also be able to bring it and you can see it's already keep green meaning that it is able to allow us to be able to to use this dimension so I'll just click on it and again to show me this it is uh it's up and once up and for this one um so once all the uh upper all of so it's about pick here so he wants these three dimensions and then we update it so we can also hide this and then also be able to update normal sorry uh right and then now we are going to run our chart and see the update so we update again there's nothing that has changed because we did not bring the dimension into a series which is going to be able to divide this so we have to bring this one and then you can go beside it too a series or so we design the series and then we'll see if you are you are testing by either below or above a police abuse below or above now remember but the year this is what I was telling you it is very difficult to visualize clearly which which which type of facility uh no which type of location is doing more more tasty was performing more tasty and and so this is where we now try to go back and see can we you know um um this put this 100 uh scale skydive to 100 so that we can be able to see um our how this uh portrays in the this kind of format that we want to be able to show and easily visualize the data and the performance across this so to do this we have options we have options here and other options uh when we go to options uh under that we have we can start add up 100 percent so we are telling the system to be able to start and add everyone percent don't worry about the rest of the options we're going to come to them but here I'm going to come in a bit and start 100 percent and then this is going to start everything and now you can see I have I just I have a good visual and I can quickly be able to tell that you know it looks like in which district that's where the performance in terms of our urban testing is happening so that was really basically to show you how to be starting and also how to be able to quickly visualize the data you can be able to save this and use it for future use uh but also um what is very key here is also to label your taxes so like for example I want to label this and also label what is being shown here so for it to be able to do your labeling now we're getting into now cosmetics make sure our chart is looking good I want to say it do not fire these are these which and then this is what this is a this is the perform so you again come back options so we'll be doing a lot of options here and they and in terms of access management you just come here and equal access and you'll see the particle and the y-axis because we are dealing with column and the column chart so it will be able to do x-axis and y-axis and here you can be able to name put your scale with your steps and all that so for example here I want to be able for the y-axis remember y-axis is this one which is up there so you just if you say auto it will pick the better name and put on the on on the axis if you just say that you're not sure anything but if you say custom it means you want to put your own so this is HIV it's the name I want to show on the y-axis you can even change the font right now make it large small you can change the position where you want it um either at the middle or at the start or on the end so this is the position on this y-axis where you want to put your level maybe you want to put the start but it appears immediately there and then you can also put the maximum range the steps within it and the the small points and all that and you have your head but also at the same time be able to level my x-axis and remember what is on my x-axis it is the distance again if I say none if I'm not sure it is by default if I want to customize I want to say the distance and again I can be able to change and say maybe it could also be at the start you can even change the color of the watch maybe this one I want it to be better to do okay I want to bold it I want to make it directs and and all that so you can be able to see this is my level of the x-axis my level y-axis which is the category I say this in this data is for okay so that was to do with being able to level your charts and then being able to stack and also to put a hundred percent cool so we can save this charge give it a good written name so you see before you save it it's that it's putting you and save realisation so you can save it from here and you can save again I can give you my initials and I say this is a hib testing by fashion for the last again better key to put what is being displayed from where and for the period and then you save the chart good so the start if you go back again to our types we've been able to do stack you can have a stacked vertical and you can also have a stack bar which is horizontal so if I do this and I update this is how it appears so you can again be able to see that it has been able to transition now like what has done is the disputes have come now to y-axis and the type of the stickers so some people may want to fight in this kind of way it's easier to analyse it takes more space and then and it gives you a good picture so that is dealing with what is the chance and then the other thing you could also want to do is to see how to download this this looks very good for my presentation or for my publication or for sharing one email with my with my you know colleagues so we have what we call download here and there are different types you can be able to download your chart we have the graphics and then the plain data source so the data behind this chart can also be downloaded to download it in this and then take it to us so the graphics is it's just going to download it as an image or the pdf building it when it's taken over there it's not going to change so if I want to let that let me just come back and you can download here and here you can have you have your chart you can save it on your computer and share it by email or or the other option is the other option is to be able to then download it as a pdf you can also just click on that and then it will download as a pdf and this is how you reply so this is just a pdf you can insert it into your white document or or the powerpoint presentation you will go for a an image if you want to add it in your presentation okay so that is just cover the download and then the other option is downloading it at the json is going to download it into a json kind of format that you can do with adding your your programming or the data input and all that xml xr and all these different types that you can download your chart as okay I want to uh before we go for a break I want to stop um by just uh looking at charts and the and sorting again uh we do these charts to allow visualization and data use and analysis and data use so I'm going to look at the situation where you want to really be able to use a chart to see your highest performing district only given in data uh we saw that in table tables you can just click and then highlight the the top one but with the chart as you see you can't move around or you can't sort you can't be able to so I'm going to take you to that one option where we can use a chart to be able to sort and see probably we are going to want to be interested in looking at the highest performing districts and the lowest performing districts so that when we put a chart instead of trying to go through and see which is the lowest performing district which is the highest we just use that kind of search to be able to display that kind of information so um the task is give us a chart that can be able to quickly show us which is the highest performing district or highest performing facility or highest performing school uh depending on what indicator you are looking at so um and I'm to do this I am going again to start from one select again to ask me whether I want to say this I say uh yes we just leave I don't want to say so that means I've lost what I've been able to do in the previous session but now I'm going to the session where I'm going to talk about the concept of being able to uh um search within a chart within a column chart so we want the column chart and here we are going to look at immunization so in immunization we have two indicators and we want to see the highest performing districts and the lowest performing districts uh for the last for last year so for start we choose the chart type we want to use the column chart okay and the data that we're going to look at is immunization coverage for DPT1 and DPT3 those are the those are the indicators that we use in immunization to be able to see which district is performing better way so um it could be also HIV testing percentage of testing or positivity rate and the number one to see where is the highest positivity rate you have over 100 districts and one to be able to show this on the chart and be able to see the highest and the lowest so the data we have to select again would be I said we want to have DPT shape and we want um the indicators and I've also looked at this already so I'm going to give the indicators so we want DPT1 coverage uh which is here and the DPT3 coverage I know this is because it's really not coverage which is this one here and the DPT3 is here the coverage with the percentage okay so I can either you can just say update when I update it takes the default but that's what the chart I wanted uh I still have to go and choose the period the period we say we wanted to be able to look at the last year which um I got period here and you should have selected which by default is is what the system has set for us this is set from the system setting some of you will find a system that the default is last three months last year and well the powers is sent as last year so it's okay but remember I want for all the districts I want to be able to see uh the performance of these two indicators for all the districts again use the other shortcut that we have instead of going in one by one and three one of course this is easy because you have only two regions but imagine if you have 10 millions and you have over 100 units which how many kicks you are going to do that goes with you so I can use this method of clicking one by one or I can select everything and I say I start at the district or even in each region and each region is in me so again this is giving me um the the chart but it's not giving me the comparison I wanted so if I want to look at all the districts I make sure I want to make sure I want to look at all of them and x axis so that would mean that I need to move the organization in today at the end the period can work in the future and the data itself and the particular service so basically this is what I have and here quickly I can be able to because I have very few districts I can be able to tell that the lowest performing district in terms of both DPT3 and 3 and the and 1 is the bad district but for me to be able to see that kind of of a scale I will use an option which we call um sorting which is under options when we got options then we go to data you have now um uh sort so when I pick on sort it allows me to specify the sorting so the sort is going to be either from high to low so I mean if you start with you have no lowest to the highest or high to low so I can be able to do this and then I say update and then people update so already if I know you may not see me that to see that it's being able to uh sort these two indicators right from this but in terms of this sorting it's using the first indicator which is in our list here this first indicator is what it's using to sort not the second one so if you had different performances it's only it's only that um this data is made up and the performance is almost uniform where with the ones that are performing badly in DPT1 they are still performing badly in that DPT1 okay we can also add a target and also maybe probably we want to see uh which districts hit the target off here our target was given as 80 percent so if I'm going to say 80 percent maybe I put the ruler here and see how many this is above 80 it may be very difficult so again the THIS2 uh fertilizer allows us to be able to insert in the target the hard target that we can be able to see that gives us a line across so again I'll go to options and other options you have the target line so on the target line you can have you have to have it in here sorry it's a no that's a 20 it's a target line you want to explain this one it's a target line so you put your value for this they have given us that for all the districts which went above 80 our target was 80 percent and uh sorry sorry it is 80 percent you just type the number and you're able to go for that line there you can give it a name this is uh uh target yeah I guess you have a name target you can even give the color type you can just go in it and know that maybe it's going to make it red and we'll give the color range and then update so this is quickly going to give me the list in the line and show me the target and I can even able to see quickly which districts have been able to go above the target and you can see all these districts staple sweets dessert and whatever have not been able to target for the last year in terms of dpt one coverage and also while if they want also to be able to do the same target you can also be able to see that they are for dpt three they also serve this with each other and you can you can turn off some of these but you're speaking on them just if you want to be able to switch between columns and one okay so that was the the target and um and uh and then lastly we need to go for a break and answer a few questions for the play uh we also introduced in legends we could also have legends into the into this uh uh chart for example we have made our legend that gives us coverage for those between this and this it's a red for those between this and that it's a two and so on so um and again this is also to the vehicles question that she was there that she was asking uh how can you change this uh we can also be able to do this so to do this um we have saved the legend uh for the bcg coverage which is um giving us a red uh orange light green dark green and uh and the and the invalid ones which are in the couple so what applied this legend to this chart to see for those which are in the you know high coverage high coverage minima and and the you know environment so again we got options and other options we have the legend again this is what you probably have seen in the table and people need and at least they can find uh they can find the legend if it was already assigned to these other elements again um I did just share that if you want the if you want to use the refined agent that means that when you're creating this with data there was an option where you have already otherwise you can use one agent here which is refined and it's called the epr coverage you call that and then you can also show the key on the side and then you have to get that uh that's your legend so meaning that for red which you already can see which is below 70 everything below 70 is right everything above between 70 and 80 is orange and then the high light green and the highest which is the line 100 which is in Australia and also in white unfortunately we don't have in the right letter which was 100 so that is really to have taken you through how to work around with the layout the different data dimensions even the extra dimensions here how to move around how to use legends how to sort how to download uh and also how apply the target lines and even sometimes put the baseline lines so let me just drop here allow three minutes question then we can take a break immediately a half past for 10 minutes and then we come back and continue again um uh I know we should have given in time for you to be able to practice this uh but again the guide is very clear you will be able to follow along but don't worry that you know I've you know been a bit fast it's just the content is quite a lot and we wanted to at least be able to demonstrate this for you so that you can be able to uh record what you're going along watch the video uh to be able to produce some of this