Getting the average of male and female

Support - Assistance technique
1

I have an attribute representing collected data on individuals gender.

How can I create an indicator calculating the percentage of each gender type, of all individual that exists in my data registered into specific tracker program?

1 Like
2

Hello @im_officer_leb, you can take the following steps:

  1. Create program indicator of enrollment analytics type, using count as aggregation, using enrollment count as expression, and code of male/female option as filter. This will give you the counts of male and female enrollments.

  2. Create a program indicator for counting total enrollments without any filter.

  3. Create an Indicator where you can use the above two program indicators for calculating a percentage, using program indicator for male as numerator and total enrollments as denominator, and same for the females.

Please make sure you have a indicator type defined as Percentage by using factor as 100.

1 Like
3

can’t find code of male/female option in the edit filter section.

1 Like
4

Hi, @im_officer_leb, assuming that you are using an option set for selection of the gender, you can find the codes in the option you have created under the gender/sex option set.

For inserting filter, you need to select the attribute (sex/gender) from the list of attributes available, and then define the option code. For e.g. <Sex/genderattribute> == ‘Male’

1 Like
5

Just one more question. Where can I test the indicator ? In which section ?

1 Like
6

You can check the program indicators individually in the pivot table/data visualiser first, by selecting program indicators under the data tab, next select the program, you will see the list of indicators. If they show data, then you can switch to indicators under the data tab, select all, and select the created %tage indicators.

1 Like
7

I’ve added data to my tracker program and select the required period with the indicator. No data is shown.

1 Like
8

Please run Data Analytics once, next clear the browser cache, and then try.

1 Like
9

how to run data analytics ?

1 Like
10

If you are on version 2.29, you can run using Reports, if you are on 2.30 in above, you can run analytics from data administration.

1 Like
11

Hi @Saurabh

What do I have to put in the PI expression to get the total enrollments (males + females)?

Thanks

12

Hi Fernando, for counting total enrollments, use V{enrollment_count} in the expression.

1 Like
13

Hi @Saurabh_Leekha87 and @Saurabh

Thanks for the response, but I have realized that my case is different from that mentioned above. We have a tracker program for strengthening health provider competencies through clinical mentorship. the tracker consists of three repeatable stages. Each stage is a checklist of yes/no data elements. We want to calculate the percentage of each individual event. i.e., Number of yes responses divided by (number of yes + no responses) X 100. If Provider A had 55% in the first event, 76% in the second and 80% in the thirst, we would like to be able list these percentages in the report per provider.

Looking forward to your help.