 Right, everyone now welcome back. So, I hope you have been trying to do the exercises the upgraded ones. We have been informed that there is some issue which is which is only effective view of you when you try to save an existing favorite items, which gives an error. Our team is trying to identify that but looks like it may be associated with some bug also. So in that case, in case if you encounter this error, what you can do is rather than trying to say edit and save an existing favorite item, try to make a make that favorite item. So you can open a bank, create new visualization and configure the data dimension, and then finally save it. So I think that will help you to resolve that issue. Yeah, please use the slack channel in if you have any issues please raise it raise it on that one I think it'd be much easier than mentioning on the zoom. Okay, so, yeah, let's move on to the next session. Fine. So now what you're going to do next is like we'll be exploring different chart types one by one and while doing that we will also explore the other options which are there in the data visualizer. When we try to make different customizations. Okay, so what we will do next is now that we are we have done that column and line. Let's try to do a stacked column chart right so what what we what we have to do once we are inside the data visualizer is first to select the chart type which is the stacked column. Right, this is done, and then we have to decide and set the data dimensions right so through the three dimensions I will first start with data, so I will first of all select the data, which is, let me take the HIV test perform. Okay, so to do that, I will click on data elements. And let me type HIV tests perform right this is the one I double click on it and select it. And I hide it. Right, and the organization unit. Let me just do some changes I'm clicking on organization unit currently it is a training land. So we will keep training land and at the level that we select district. So what we essentially do here is like we filter all the data that is coming to the visualization to the training land and the level at which the the disaggregation happens, we define a district. Okay, right. I hide it. Right. So the period type. Let me check what is a period type that is there which that is last 12 months I will just keep it as it is. Now I have set all three series category and filter, let me click on update. Fine. Now that I have clicked on update. Yeah. If you have any questions. You're unmuted. I hope not okay fine. So this is the visualization that we get. Okay, so here of course, you don't see anything much even though it's a stack column we just see plain columns right and the x axis is obviously the period, and the y axis the data values. And here we see the district levels in training lab. Right, that's how the data has been configured in this visualization. Any questions. I hope not right now to make the maximum use of this type of chart which is a stacked column we need to stack this column right currently only one item is display. So to do that, let me add one other dimension right here we have the available dimensions I'm going to select this one. Urban ruler. Okay, so I click here. Okay, and then I'm going to add it to the series. I click on add to series. Then I select all three of them. And finally, I click on update. Right. When I do this, you can now see the my chart change. So, if I repeat what I did just now. I focused on this available dimensions right and I clicked on a ruler and add to series, and it has come here. So you can see what are what is available in the series dimension it has changed previously it was the data that is there. And now it's the series. Okay. So, if we try to focus our attention on how these three options have been configured now you can see everything in this visualization is filtered based on. Questions. You need you have a question. Fine. So, we see that everything that you see in this visualization has been filtered by the organization unit which is training land by district level. And the data is also filter. That means like we are not doing any changes in the layout for this open it and the date. But now in the layout, what has happened is the categories is last 12 months that is why we are seeing 12 months in the x axis and the series. We have urban and rule. So what has actually happened is the category dimension but the series does is it groups the category dimension so it has been grouped and because we have selected stacked column, you are seeing that these values have is stacked. Okay. Right. I hope it is clear up to this point. Now I have a question. If you want the organization units to be in our x axis, in order to display the number of features we test performed within each locality by district. What are the changes we have to do the organization unit dimension. Let me repeat. If you want to have the organization units to be in our x axis, what changes do we have to do. I think you can put that we can put the organization in the category category and update the chart. Okay, let's let's try to do that. Let's move organization unit to categories, as you suggested, and I click on update. What actually happened. Whatever. I hope this was not what you expected right. Yeah, so what what are other changes should I do. Exactly. Just put the period to filter so that we will have a less crowded less complicated chart, I will explain what happened here bit later, but I will just move the period here and click on update. And this is what we get. So this is good enough right as per our expectation. Okay. Right. Fine. So are you happy with this issue. Everyone. Yes, no. Okay, somewhat. What do you think. This is okay. Actual as well seen depends on what you want to show. So if we want me to show the for each and every district, the web submission of urban, this can be okay. So right now in this visualization we are seeing data for all the districts and for all the districts we are seeing this disaggregation by urban and rural and peri urban. So that is all there. So that means this is good enough right or anything you would like to do to make it better. Any any disadvantage in this particular visualization we are having. Yes, I see in sweet district. All three categories are very very rural but not clear. Not clear. Why it is not clear. What has happened why does it make it not clear. What's the issue issue is with the sweet district. Yeah of course or is like what has gone wrong here not wrong but what actually contributes to this type of visualization we are some districts the values system I mean it's not that clear. What's the reason. It's because the values are high. The values that the numbers are quite high so those with smaller numbers will really not be very clear to the visualization. Exactly. So there are some extreme. You can even say outliers right some districts because we are just comparing raw values here. What happens is like there are some districts for example fish districts. The numbers are really high so really high right when we are trying to draw this graph but DHS to has done is to accommodate that one is that it has kind of scaled up the the y axis and we are seeing like all this tick tick marks are like 100,000 right so see you can see this crossing 400,000 mark. But when it does that these small districts which has maybe less population. They are not that clearly clearly display to overcome this what can we do. There is something very simple that we can do, we can click on options, right, and we can click here stacked values at up to 100% right so I just think of what we are doing. Right, I just stick here and I click on update. And this is what I'm getting. Now are you happy. Is this much better. What do you think much better, much better but but by making it better what other changes happened in the chart. Now we see all the visualizations stacked columns clearly, but what else happened. What happened to the y axis. We have to change between 0 to 100. It before it was between the lowest to vary up and the highest to vary on the graph. All right so that does that mean like all the values about 100 have been cut off and we are only seeing from 0 to 100. Is that what happened. Something else happened. All the bars have been converted to 100 0 to 100 they have brought they have been brought to the same scale. So the absolute numbers may not make sense with the axis. I think it would be better to depict them as percentages. Yeah, so in fact like what is what actually has happened here is the percentages like you can see here this is I mean, so let me let me show you again what we did. First we ticked this option which does fact values add up to 100% so what it has actually done is it's kind of like make all the values that are adding up to this column as a proportion right so you have the raw values displayed as labels you can see here 21,000 and 3490 but in the y axis it's actually the proportion from 0 to 100% so basically what you're seeing here is a percentage. If you actually want to have an idea about the raw values in the data element, you can see it because we have the raw values mentioned here. Is that clear. That's actually what happened. Okay. Right. And let me again show you something. Just. Just keep it there. So in this stack value. Can we compare district wise. What do you think. I don't think so, because everything is. We have converted to 100. Yeah, everything is converted to 100. Like, this is what happens. So for example, I mean, again, I'm coming back to what I said before, maybe stacked column is not the ideal chart type for comparison of trends. So like, let's just look at desert, the dinner and dog districts, we can see the peri urban proportion is lesser in this one, and it's higher, highest in dog district right so likewise you can compare, but still, like if you want to compare between cat and staple right or maybe a couple of more districts. It's not the best type of the charts, but still you can get some sort of an idea so it totally depends on how you interpret and if you feel like okay this is this may not be the best visualization we need to go for a line chart, you can do that. So for example, yeah. Sorry. Alright, so. Is there any questions up to this point. If not, we can see what other things which are available in this options now that we have touched on this option step in the DHS to. Okay. Let me click and open these options. Right. So here we have a couple of them, like we have cumulative values, height, empty categories, custom sorted trend line, right. These are the ones which are there in the data tab, and we have access tab, right, and we have a series tab, and of course, style, right. So for example, now I mentioned, here we have the values that displayed in each of the bars. So if I just click on value labels and update it see what happens. So if we don't see the values in this individual bars. Now, now does it make sense, we can still see if we hover my mouse pointer. But if not, at a glance you can't actually see the raw values. So which one do you prefer the one with the values or one without the values. Yeah, of course, because I mean when we have the one with the values we can make better sense just by looking at it. So obviously I prefer that. Right. Okay. Excuse me. Yeah. Even though most of the time we prefer to use with values but I think also it would depend on the type of the audience you are presenting. Because, for example, when you are maybe with some high review authorities, the actual most of them they don't want even the exact values they want just to see which category is performing which category suffering. So I think it's all depends. Most of them to depend on the audience. Exactly. So I definitely like I have to agree with you like because it's totally up to you, but you just have to know the limitations and you may need to think of from the perspective of the end user. So, only only issue that that can happen is because sometimes maybe we are technically advanced, we may not kind of see it from their angle, like how confusing our visualization needs or like whether they can make anything out of it. So this is where this will be discussing in last day or implementation considerations as well. So this is where it is very important like once you have configured this visualizations and the dashboards should always do a pilot so that you can get a feedback you can ask from the end users okay what when you see this chart in the dashboard, what do you understand. So we might think okay now they will be able to you know compare and they will get an idea so they will not repeat. They will have a, they will look at it and maybe they will write interpretation. I mean, these are our expectations, but if they are not meeting our expectations then there can be so many reasons. One of the reasons maybe our visualizations are too complicated or like it's very, I mean, like to advance for the end users to grasp. So these things we will have to consider. Okay. So right now our X axis, what we can do is now these axis we don't have any titles. So we can put axis titles, right. So here we have what like for the Y axis we can put a title or HIV test. Right. And we can click update to see how changes it does. Yeah, you can see now it's HIV test which are updated. We are seeing that we have a label here. Right. And in addition, now there are a few other options in the axis as well. So for example, we can in fact, set a range to the axis to do that. What I have to do is let me disable this stack value set up to 100. When I do that, right. Now I'm seeing I'm going back to the previous one. Now one problem we had before was, we are I mean, our Y axis is from zero to 500,000. But what we can also do is like we can just, if you want to just focus on this table district or like few other districts like this, we can just try to keep it at 100,000. So let me try to do that. I will just put the axis range. So let me set it to zero and maximum 100,000. And let's see what happens. What happened here. So now, our axis is ranging from zero to 100,000. And you are nicely seeing that at least these four districts, it has reached this 100,000 mark, right. But when you hover over these each of the columns you are seeing it's exceeding 100,000. So what we essentially did was to define a range in the Y axis. But this may not be a very good idea if you want to put this kind of a visualization as a permanent item on a dashboard, because easily, you might distract the user to believe that okay now, it's just 100,000. That's it. No, it's not really same. It's just that when you are trying to interpret or you just trying to present your dashboard to someone. So if you can do things like this, you know, like you limit the range of the axis and try to focus on some districts, those kind of things you can do at that point, but maybe not a very good idea to save it and keep it as a dashboard item. Is that clear. Yes. So let me just love it. Sorry, I'm having this visualization. Okay. And in addition, we also have in the axis, the steps, right. So steps is this tick steps. Let me set a value of like 10. Yeah, and click update. And you can see these lines that you see right this shaded lines are the tick lines. So we have 10 of them. So that's what it does. It automatically like based on the range of the value it may have like 304, but if you want to increase the numbers, you can do like do it like that. Right. So likewise, there are a few other things that you are you can do and you can try them out I'm not going to do everything. And here, when you put these labels, even the text you can select a color and make it bold or italic and also select the size and the position, the alignment also you can set. So for example, if I want to put it at end, make it bold, pick update. This is what happened. It was previously here now it has moved to here. Okay. Right. Fine, so any questions on what we have done so far in this session. If not, I'm trying to move on to the next type, which is bar charts, right, and we will also touch upon target lines. Right. So. Okay, now what I will try to do now is to convert this chart to a bar chart. In fact, stacked bar chart so it's so easy to do that I just change the stack column to stacked bar. That's the only change I do, and I keep these as it is, and I click on update and let's see what happens. Excuse me. Yeah. Can you change the colors of those tracks? Sorry, I didn't get what I mean is there any way to change the carers of those bar charts. The colors of the bar charts. Okay, so there are options. What we can do is there is something called slide in the style type I didn't touch that one yet but I will just do it show it because it is already there. So there are some color sets that we can, you know, like change. So let me set it to gray and update. And this is what happens. So right now, we have preset colors on this version 2.35 that we can set, but this is something that keeps on changing. So for example, 2627 versions, they are trying to look at, you know, like to introduce legend sets so that you can apply the legend colors. But ultimately, there will be more flexibility in time to come to change the colors because this is one of the highly requested features in DHS to, but as of 2.34 this is all what we can do we can change the colors based on this color sets that is there. Okay. All right. Let me also make this one 100% stack. So, this is what we have. Okay. So we are now now all right. So, can you comment on what has now happened what was the difference between stacked stacked column and stacked bar. What are the changes that you observe. You can see like previously it was vertical lines now you have horizontal line so that dance I have. It's from my end like any other changes that you see. Can you comment on series category and filter and how it has changed from stacked column to stacked bar anything change or it's the same. So, you can see right here now these are the, now, for example in the column chart. Our categories the category dimension was in the x axis. Okay, but what has happened to category dimension now it has moved to this is why right and the data is now in the x axis. So, it's kind of flipped from the axis which are there in column and bra the bar charts, they have flipped. Okay. Right. So that's one major difference that you have to know. But obviously, I mean like, it doesn't make a major difference to the end users but the layout and the visualization and how pleasing it is is what you have to decide when you are, you know, like comparing between putting a bar chart or a column chart. Now, again, going back to the options. Right. We have looked at the color set that is to change the colors of this. That's the series, and we can also put a title. Right. So that option is there. So right now, what happens is the title is auto generated. Right. But if you want to put our own title what we can do is we can click on custom. Right. And I can put my own type. So I will put HIV tests by quality and district and I keep it at center every bold right and update. Now you're seeing. Okay, this is HIV test locality and district that that's the title that appears so it has replaced the previous auto generated type. That's what happened. Right. Similarly, if you want to, you know, get rid of now currently we have a subtitle if you don't like the subtitle we can click on none and update and you see that the subtitle previously which was there. It is now disappeared. And we also have a tab here called download. And let me show you what happens it's quite straightforward when I click on download, I can download this visualization as a image or as a PDF. There are other types like Jason Excel CSV and so many others if you want to take the raw data out of this visualization, and maybe you want to create a different graph or chart outside the DHS to so for that one you can use it. Here if I click on image, it'll download the image and the image will be visualized like this. So note that image will have the titles and the access titles that we have, we have defined when we are doing the configuration. Okay. All right, so any questions up to this point. If not, let me know create a new chart so to create a new chart what I can do is I click on file and then new right here. And let me select a different indicator. So to do that I click on data dimension and I select indicators and let me search. D P T. Okay, I guess it is not available. These two. Now I want to select D P T hepatitis B hip one coverage and three coverage. So I'm going to select these two indicators, and I selected here. So my data is selected. Right. And then the period I click keep from. Comes by default. Then the organization unit. I keep it as training land. Then I click on update. And by default it was selected chart and this is what I see. Anybody has any questions. So we are back to with this particular visualization which is a column chart. And what we can do is, there is something called now, right now, you are seeing to two indicators one is the, the one coverage. The second one is D P T three coverage, right. So you are seeing two different bars for each of the period, period which is available. And this data is currently now so just displayed as it is, like that what I mean by as it is is like, it's just per month, so the values that is now displayed. Okay, so let me just flip this chart a bit so that what I can do is I can just move organization unit to the x axis, and period I will keep as filter. Right. So what my objective is, I want to have, instead of the periods, the months in the x axis, I want to have all the districts, right in the x axis. Now I have done this but only thing right now it's a training land. So to get the districts what I have to do is, I will just select the training land, I will scroll down, and I have to select the level district. Okay, then only the districts will have come. So let me just show what happens if I don't select the district. I will just keep it as it is and I click on update. This is what I get, because these two bars just represent the training land. So to change it, what I will do is I will scroll all the way down and select the district, right, and click on update, and this is what I get. Okay. Right. So we have data from bird cat desert dinner likewise. And what I'm going to do is, I just click on options. Right. And then there is something called custom so told. Now the thing is my objective in this visualization is I should be able to easily compare between the district. So right now it's a bit difficult to compare because the values are not in a proper order. So to do that, I just click on custom so to do. And I will select low to high, and I click on update. So what actually happened. I can now see that the order that was previously there has now changed because the bird district is here but like sweet district which was previously here has come here. Right. Now has it been sorted. Do you have any questions about this sorting. Let's have a question. Is the order the increasing order sorted based on because I see the green bar and the blue bar or going in the same order was it not reassorted. Yeah, good question. So what has actually happened is when we do that, when we do this sorting, it will always take the data element which is at the top. So here. Remember this order now it's but is it. So you can just maybe look at the fish and insect load of that one. Like, let me show you something I click on data. Right. And I just try to flip it. So three comes first and one comes after that and I click on update. Now what happened. Right. So it always take into consideration the one that is. It should be taking the this one like so because like one which is at the top. Or is it not. It should ideally be taking the one which is at the top. I mean, the one which is here. So here also it is. Yes, it's actually the green one is dpt three coverage. So it always take only the dpt three coverage which is the first one which is appearing on the list. You see that don't don't don't try to remember with the colors. Now the colors also have flipped. I just wanted to understand because it was initially dpt one, but now it's a dpt three based on which it is the sorting orders arranged. Is that here. So whichever one if there are more, more data items which are there in the series dimension is whichever the one right at the top is the one that is taken into consideration when it when it is so when it is sorting that it is from low to high or high to low. Okay. Right. And also let me show you something. Now here, we have two items in the series right one is in green other one is in blue. So when we hover over each of the one in this, the legend, you can see that that one is getting highlighted and and similarly if you want to hide it in the visualization, we just click here and you're only seeing the one that is enabled. So basically you are now seeing only the dpt one coverage right and do like this it's only dpt three. Now nothing right so that way you can click and disable enable the visualizations right. Let me also so you something in addition, we can draw some lines right so basically, when you look at this data, we see like a lot of data is in this 50 60s range. So if we want. What we expect like at the country level we can set a target, we call it setting a target right. So say for example if we can set the target of 80 for the and put it as target coverage. Right. And let me click on update. This is what happened. And you see, like, we can draw this line horizontally and give it a name, a label called target. So when we have this kind of a line in between it's it really helps us to see which districts have performed above the target which are less. Right, so it's just a line that we draw on this visualization. So similarly there are a few other lines right, we have baseline, so baseline also we can set that value so let me just put in for now. Let me click update, you can see this one right, it's baseline. Okay, is that clear. So, I guess that's it for the columns and bars. I think we can move to the pie charts next but before that I think we can take a little bit of a break. Excuse me. Yes. I will leave this slide. I have been trying that when you click on one of the categories. Let me say one of the, for example, here we have APDP 3 coverage and one coverage. I've seen that when you click on one of them, the other ones is somehow hiding. So, what if we try to download this, will it bring the one selected. Let's try to do it. So I'm going to click on download here. Yes, an image. This is what happens right. So it does not hide it in the download. So basically download takes into consideration the permanent type of changes that we do. So whatever we are doing here, it's not appearing in the download. So in case you want to just totally hide it, the best way is you just remove it, you know, like from this and try to download. Okay. Yeah, right. Fine, so I think we can take a break. This is the time we have. Yeah, kind of the mid ways. Today is a kind of a lengthy day because there are so many topics to cover. So, yeah, I think we can take a little bit of a break. And maybe meet again in in 10 minutes time. In the meantime, what you can do is, so okay, now I would ask you from, I mean, I will give you the opportunity to decide so there are two things we can do, we can actually try to do the ungraded exercise part three and four. Now, right or else, we can proceed with the sessions and towards the end you can do both the ungraded and graded, which option you prefer. If you want to practice, we can do it for like 10 minutes. Yeah, I guess no. 10 minutes. All right, it seems like at least 10 minutes. Okay, fine. Yeah, so please try to like if you want to break you can take a break of 10 minutes or else during the break you mean whoever was comfortable continuing you can proceed with the ungraded exercises and we will resume the next session in 10 minutes right so local time is 302. So maybe in eight minutes, sorry about that. So we'll start again at 310 local time. Okay. Thank you. Okay, and let us know the water. Definitely. I mean, that's what I'm going to start.