search

opensrp / opensrp-client-reporting

In app Reporting Client Library
Other
1 stars 7 forks source link

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

Open msschroeder opened 4 years ago

msschroeder commented 4 years ago

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

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

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 commented 4 years ago

@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