Update the in-app reporting to include male family planning values

[msschroeder]

• We would want to add some additional indicators for the Male FP including:
• Number of new clients - Male broken down by 10 - 14, 15 - 19, 20 - 24 & Number of revisiting clients - Male broken down by 10 - 14, 15 - 19, 20 - 24

Counts for the males are added below and included the previous indicator with the added filter by sex = 'Female' included

Number of new clients - 10 - 14 years

Indicator	How it is calculated
Total number of new men clients	Count of FP registrations and filtered by those that are not already on a family planning method (i.e. using_method = no) and age >= 10 and age <=14 and sex = 'Male'
Total number of new women clients	Count of FP registrations and filtered by those that are not already on a family planning method (i.e. using_method = no) and age >= 10 and age <=14 and sex = 'Female'
Number of return men clients	Count of FP registrations and filtered by those that are already on a family planning method (i.e. using_method = yes) and age >= 10 and age <=14 and and sex = 'Male'
Number of return women clients	Count of FP registrations and filtered by those that are already on a family planning method (i.e. using_method = yes) and age >= 10 and age <=14 and and sex = 'Female'
Total number of return clients	Old Section total of this section + the added male sections noted above

Number of new clients - 15 - 19 years

Indicator	How it is calculated
Total number of new men clients	Count of FP registrations and filtered by those that are not already on a family planning method (i.e. using_method = no) and age >= 15 and age <=19 and sex = 'Male'
Total number of new women clients	Count of FP registrations and filtered by those that are not already on a family planning method (i.e. using_method = no) and age >= 15 and age <=19 and sex = 'Female'
Number of return men clients	Count of FP registrations and filtered by those that are already on a family planning method (i.e. using_method = yes) and age >= 15 and age <=19 and sex = 'Male'
Number of return women clients	Count of FP registrations and filtered by those that are already on a family planning method (i.e. using_method = yes) and age >= 15 and age <=19 and sex = Female'
Total number of return clients	Old Section total of this section + the added male sections noted above

Number of new clients - 20 - 24 years

Indicator	How it is calculated
Total number of new men clients	Count of FP registrations and filtered by those that are not already on a family planning method (i.e. using_method = no) and age >= 20 and age <=24 and sex = 'Male'
Total number of new women clients	Count of FP registrations and filtered by those that are not already on a family planning method (i.e. using_method = no) and age >= 20 and age <=24 and sex = 'Female'
Number of return men clients	Count of FP registrations and filtered by those that are already on a family planning method (i.e. using_method = yes) and age >= 20 and age <=24 and sex = 'Male'
Number of return women clients	Count of FP registrations and filtered by those that are already on a family planning method (i.e. using_method = yes) and age >= 20 and age <=24 and sex = 'Female'
Total number of return clients	Old Section total of this section + the added male sections noted above

Number of new clients - 25 years +

Indicator	How it is calculated
Total number of new men clients	Count of FP registrations and filtered by those that are not already on a family planning method (i.e. using_method = no) and age >= 25 and sex = 'Male'
Total number of new women clients	Count of FP registrations and filtered by those that are not already on a family planning method (i.e. using_method = no) and age >= 25 and sex = 'Female'
Number of return men clients	Count of FP registrations and filtered by those that are already on a family planning method (i.e. using_method = yes) and age >= 25 and sex = 'Male'
Number of return women clients	Count of FP registrations and filtered by those that are already on a family planning method (i.e. using_method = yes) and age >= 25 and sex = 'Female'
Total number of return clients	Old Section total of this section + the added male sections noted above

Number of new clients - Total

Indicator	How it is calculated
Total number of new men clients	Total count of FP registrations and filtered by those that are not already on a family planning method (i.e. using_method = no) and sex = 'Male'
Total number of new women clients	Total count of FP registrations and filtered by those that are not already on a family planning method (i.e. using_method = no) and sex = 'Female'
Number of return men clients	Total count of FP registrations and filtered by those that are already on a family planning method (i.e. using_method = yes) and sex = 'Male'
Number of return women clients	Total count of FP registrations and filtered by those that are already on a family planning method (i.e. using_method = yes) and sex = 'Female'
Total number of return clients	Old Section total of this section + the added male sections noted above

• Number of males taking male condoms - broken down by 10 - 14, 15 - 19, 20 - 24 & Number of males taking female condoms - broken down by 10 - 14, 15 - 19, 20 - 24

Counts for the males are added below and included the previous indicator with the added filter by sex = 'Female' included

Condom (new and return users) - 10 - 14 years

Indicator	How it is calculated
Number of men who took male condoms	Count of FP registration/Stop or Change Method where fp_method_accepted = male condoms and filtered by age >= 10 and age <=14 and sex = 'Male'
Number of women who took male condoms	Count of FP registration/Stop or Change Method where fp_method_accepted = male condoms and filtered by age >= 10 and age <=14 and sex = 'Female'
Number of women who took female condoms	Count of FP registration/Stop or Change Method where fp_method_accepted = female condoms and filtered by age >= 10 and age <=14 and sex = 'Female'
Number of men who took female condoms	Count of FP registration/Stop or Change Method where fp_method_accepted = female condoms and filtered by age >= 10 and age <=14 and sex = 'Male'
Total number of clients using condoms	Total from this section

Condom (new and return users) - 15 - 19 years

Indicator	How it is calculated
Number of women who took male condoms	Count of FP registration/Stop or Change Method where fp_method_accepted = male condoms and filtered by age >= 15 and age <=19 and sex = 'Female'
Number of men who took male condoms	Count of FP registration/Stop or Change Method where fp_method_accepted = male condoms and filtered by age >= 15 and age <=19 and sex = 'Male'
Number of women who took female condoms	Count of FP registration/Stop or Change Method where fp_method_accepted = female condoms and filtered by age >= 15 and age <=19 and sex = 'Female'
Number of men who took female condoms	Count of FP registration/Stop or Change Method where fp_method_accepted = female condoms and filtered by age >= 15 and age <=19 and sex = 'Male'
Total number of clients using condoms	Total from this section

Condom (new and return users) - 20 - 24 years

Indicator	How it is calculated
Number of women who took male condoms	Count of FP registration/Stop or Change Method where fp_method_accepted = male condoms and filtered by age >= 20 and age <=24 and sex = 'Female'
Number of men who took male condoms	Count of FP registration/Stop or Change Method where fp_method_accepted = male condoms and filtered by age >= 20 and age <=24 and sex = 'Male'
Number of women who took female condoms	Count of FP registration/Stop or Change Method where fp_method_accepted = female condoms and filtered by age >= 20 and age <=24 and sex = 'Female'
Number of men who took female condoms	Count of FP registration/Stop or Change Method where fp_method_accepted = female condoms and filtered by age >= 20 and age <=24 and sex = 'Male'
Total number of clients using condoms	Total from this section

Condom (new and return users) - 25 + years

Indicator	How it is calculated
Number of women who took male condoms	Count of FP registration/Stop or Change Method where fp_method_accepted = male condoms and filtered by age >= 25 and sex = 'Female'
Number of men who took male condoms	Count of FP registration/Stop or Change Method where fp_method_accepted = male condoms and filtered by age >= 25 and sex = 'Male'
Number of women who took female condoms	Count of FP registration/Stop or Change Method where fp_method_accepted = female condoms and filtered by age >= 25 and sex = 'Female'
Number of men who took female condoms	Count of FP registration/Stop or Change Method where fp_method_accepted = female condoms and filtered by age >= 25 and sex = 'Male'
Total number of clients using condoms	Total from this section

Condom (new and return users) - Total

Indicator	How it is calculated
Number of women who took male condoms	Total count of FP registration/Stop or Change Method where fp_method_accepted = male condoms and sex = 'Female'
Number of men who took male condoms	Total count of FP registration/Stop or Change Method where fp_method_accepted = male condoms and sex = 'Male'
Number of women who took female condoms	Total count of FP registration/Stop or Change Method where fp_method_accepted = female condoms and sex = 'Female'
Number of men who took female condoms	Total count of FP registration/Stop or Change Method where fp_method_accepted = female condoms and sex = 'Male'
Total number of clients using condoms	Total from this section

• Number of males given a FP referral - broken down by 10 - 14, 15 - 19, 20 - 24

Counts for the males are added below and included the previous indicator with the added filter by sex = 'Female' included

Indicator	How it is calculated
Number of women given referrals (10 - 14 years)	Count of FP Referral filtered by sex = 'Female' and age
Number of men given referrals (10 - 14 years)	Count of FP Referral filtered by sex = 'Male' and age
Number of women given referrals (15 - 19 years)	Count of FP Referral filtered by sex = 'Female' and age
Number of men given referrals (15 - 19 years)	Count of FP Referral filtered by sex = 'Male' and age
Number of women given referrals (20 - 24 years)	Count of FP Referral filtered by sex = 'Female' and age
Number of men given referrals (20 - 24 years)	Count of FP Referral filtered by sex = 'Male' and age
Number of women given referrals (25 + years)	Count of FP Referral filtered by sex = 'Female' and age
Number of men given referrals (25 + years)	Count of FP Referral filtered by sex = 'Male' and age
Total number of women given referrals	Total of this section

- Number of males that were provided advice - broken down by 10 - 14, 15 - 19, 20 - 24 NOT NEEDED

[msschroeder]

@paulinembabu I have updated the data dictionary (https://docs.google.com/spreadsheets/d/1l0XxycZRMAWRCexuSjc4YjarTvRD8Wk4V3xDNaXS_ug/edit#gid=802816527) and highlighted the added fields in a pink. I have also included the count the counts above for the sections (including the updated fields for women). Please let me know if you have any questions