 to see the total number of males and females given these doses I could generate a pivot table style or table style of aggregated information from the events. If I have to see line listing of the cases then I could list down the events and I could add my filters based on what my line list will be updated. Then the reports which we generate they can be saved as you've seen for other data analysis for pivot tables visualizers. Similarly for event reports these reports can be saved as favorites they can be downloaded and we could also add them to the dashboards. While creating an event report we always need to identify the program for what program we need to see the report and the analysis is based on a range of dimensions and filters like data elements periods and organization units. When we'll be generating these reports for the tracker data there are two kinds of reports that we'll see one is event and another is enrollment. Now how are these different? So as we've seen in the data model for tracker there are tracker programs which have program stages and program stages have events within them. So if we create an output of event type then we'll be able to see the data from all the events within a single program stage. So we have a program stage and we have multiple events we might have multiple events within the same program stage. So event report will always show you data from all the events within that program stage. To generate an event report you first need to identify your program stage and then specifically generate data for the events within that program stage. But for event reports we cannot use multiple program stages. So we cannot have, cannot however view or summarize data from multiple program stages using this output type. So when we say event we must select just one program stage. While when we use enrollment type of output here then we can see the data across different program stages. So you across the program for the multiple program stages you can view the line listed data. So it will show you data across the entire enrollment within a program. Now when we have program stages with repeatable events we'll always see data from the most recent event. So because this is enrollment and it is going to show you data from all the program stages it will always pick up the latest event from a program stage. These concepts will get clearer when I give you the demo because we'll focus on each of these points. Yeah so I'll start one by one with all of these concepts and first we'll see how can we generate a pivot table and a line disk type of event report. So I will move to the demonstration now on my demo instance. I'll show you these two kinds of reports and then I'll give you time for practicing the same on the exercise instance. So this is my demo instance this is the event reports. Most of you would have seen this already but just a quick revision of the interface. So in the event reports we can select the table style. Do I want to see a pivot table or do I want to see a line list. So pivot table will show me the aggregated values and line list will show case wise individual rows. We can select our output type as event or enrollment from here and we'll see how are these different. Then we have the data that we have to select. So in the data we need to select the program first. What program do we need to analyze. After selecting my program then I need to select the program stage. When I select event type of output I can select one stage and show the results. When selecting enrollment type of output I can select multiple stages here and whenever I select the stage my data elements attributes program indicators all of them will be available here. I can double click them to select them. Then as we know for analysis we have data periods and organization units. So we after data we need to select the periods. We could either have fixed and relative periods similar to what we have in pivot table. We can select our period type from here and select the periods. We could have relative periods. Additionally for the event reports we have option to select start and end dates. So you could select here exact start end dates if you want to see events within a particular range of dates. So you can do that selection from here. Organization unit again we have fixed and relative. I could either select based on this or I could select based on user org units. So this interface is same as the pivot table and data visualizers that we have. From here we could update our selection save favorites change my layout. We'll be trying out these while I'll be generating a report. Okay so to start with our first example and see how our table styles for pivot table different from line list. I will start with creating one pivot table and event type of output for now. I'll just show you what will be generating and then I'll show you how we can add that. So we have a favorite I'll just open that and show you. Now if we want to see for my COVID-19 case-based surveillance program in a group of ages I want to see how many males and how many females were positive. So basically I want to see confirmed COVID-19 cases gender-wise and age-wise. So you see my age categories I've already created these categories as legends. So my age categories are here and my gender breakup male female is here and all of these are positive cases. This pivot table will allow me to see aggregate information for confirmed cases by age and sex. So let us see how this table can be generated right. So I'll start with my selection. I need to generate a pivot table of event time. What is my program now? So in the data I will select case-based surveillance program because that is where my lab results are being entered. So I'll go to case-based surveillance program and my stage for the lab results is lab results. So I will select lab results program stage. This would show me all the attributes and all the data elements specific to the lab results program stage. Now I have to make my selection for age and gender. So I would say age, I would say sex and I have to see the results. I have to see confirmed cases. So I would select lab test results. Since I only have to see positives, my analysis that I want to see is positive or confirmed cases age and sex-wise. So I would say show me lab results which are positive. So it will only filter out the cases and they give the cases which have positive lab result. And for my age, I have these ranges or legend sets. So I will use the legend for COVID-19. So this is my data age, sex, lab result. Now for my period selection, maybe I want to see data for entire this year and I want to see the data for the entire country. So I've done this selection and I will update. Now we can change the layout how we want to see the data here. So in the layout, in my columns, I want to see the, I can just remove these filters, OU and periods because they, I don't want to see them on the columns. I want to see lab result which is positive and then I want to see male-female-wise. So I've done the selection as in the columns here, I want to see male-female and in the rows here, I want to see age. You can play around with this layout and generate based on what suits your requirement best and it'll keep on updating. So you can try out different options and layouts yourself in practicing. If I update this now, so as you see age is in the row which is this legend and positive male and female are listed here. Right? So this gives me the required analysis. Now if I want to change my legend, say I don't want to see so many age categories, I have another legend for COVID cases which I want to use. So where I selected age, there only I could say use this legend and update. So you see the legend is updated based on the new category, right? So generating this pivot table, I selected my attributes, the legend that I want to see for age, the data element based on what I want the application, period, OU and updated. So this is how my pivot table for the event report based on the tracker data is seen, right? Now we'll also see example of creating one line list and after I add the line list, you could practice this once at your end. Okay, suppose I want to see list of cases who have been given first dose of COVID-19 vaccine. Right? So what I want to see, I'll just show you one example. Okay, so I want to see, show me all the cases, all the line listed cases, their names and names, sex, what vaccine is given to them and which dose. So this is like second dose, all the cases with second dose of vaccines. I'll try to generate one line list with first dose of vaccine, all the people given first dose of vaccine. How do I do that? So here I'll come back to the selection. Now, as you know, we have to select see line list. So in my table style would now be line list. So here I would say line list. I am still concerned with the events because I want to see the first dose which is given. So I'll stick to event and now where am I reporting the vaccine? It's in the COVID-19 vaccination registry. So I will select this program. I'll select the vaccination stage and my fields that I want to see in the line list. So I could select all of those. Maybe I want to see first name, surname, sex of the person is national ID to identify the person and then I need to see what is the vaccine given. So vaccine name. I also want to see the dose of the vaccine. So dose number, right? So I've selected first name, last name, sex, national ID and vaccine name. Now my requirement is I only want to see the people given first dose of vaccine. So in my data element for dose number, I could say first dose. So this will give me only the first dose of vaccine. Right? So I filtered for first dose. Now my period selection, I again keep it to this year for the entire country. So this will give me line listed cases given first dose of all the vaccines. I can change the layout. Maybe I want to see ID before the name. So there is this layout option wherein you could sort it out. So I could say move national ID first and update. So as you see now national ID comes first and first names are named sex vaccine dose number. Similarly, I might want to see people given second doses. So here instead of first dose, I could select second dose and the table will be updated. Maybe I just want to see people who are given AstraZeneca. Out of all the vaccines, I just want to see the line list for AstraZeneca vaccine given to patients. So if I select this filter for the vaccine name and I update. So only AstraZeneca list. So it will filter down the list to only the people given AstraZeneca all the doses. I could further say who are given first doses of AstraZeneca. It will filter out. So based on your selection here and filtering out further different data fields, you could update your table. Right? So we've seen how to generate a pivot table from event report and how to generate a line list from event report. As you've seen for other analysis app, similarly, we could save this as a favorite by going to save as giving it the name and saving. This will be saved as favorite and then you could add it to your dashboards. You could also download this in the following format. Right? So now we could move to exercise one which gives you steps and screenshots which you could refer to on how to create similarly a pivot table and a line list. So we'll give you 10 minutes. You could practice and you could ask your queries during the same time to see the exercise. If you go to your modal interface for today's session, which is event reports, there you would see event reports, learners guide. If you go to the learners guide, you have exercise one, which is to create a pivot table event report and to create a line list event report, which is here. Yeah. So both of these you could practice in the next 10 minutes.