Thanks very much. That is what I was doing but it took several tries for it to finally appear correctly in pivot tables, which it now does. Evidently even after running analytics and clearing all the caches and browsers, my system takes a while to update…
Best and thanks again, Jennifer E. Spratt, Ph.D. Senior Education Research Analyst International Development Group at RTI International Email: spr...@rti.org<mailto:spr...@rti.org> Skype: j_spratt Mobile: 443-562-2129 Messages: 410-235-0019 From: Jason Pickering [mailto:jason.p.picker...@gmail.com] Sent: Tuesday, January 02, 2018 1:59 AM To: Spratt, Jennifer <spr...@rti.org> Cc: Shurajit Dutta <shurajitdu...@gmail.com>; dhis1-users <dhis2-users@lists.launchpad.net>; Alexander, Keely <kalexan...@rti.org>; Kochetkova, Emily <ekochetk...@rti.org>; Preston, Adam <apres...@rti.org>; Pavluck, Alexandre <apavl...@rti.org> Subject: Re: [Dhis2-users] Constructing indicators from boolean data elements Hi Jennifer, With aggregate data, Boolean "Yes" values will have the value of "1" in analytics, while "No" values will have a value of zero. So, it should just be a matter of creating an indicator like: Numerator: Your data element Denominator: 1 Indicator type: Percentage That should provide the percentage of values which responded "Yes". Regards, Jason Pickering On Tue, Jan 2, 2018 at 1:01 AM, Spratt, Jennifer <spr...@rti.org<mailto:spr...@rti.org>> wrote: Thanks very much, but I am working with a dataset not a program, so how do I access the relevant data elements in the program indicators construction app? Jennifer E. Spratt, Ph.D. Senior Education Research Analyst International Development Group at RTI International Email: spr...@rti.org<mailto:spr...@rti.org> Skype: j_spratt Mobile: 443-562-2129 Messages: 410-235-0019 From: Shurajit Dutta [mailto:shurajitdu...@gmail.com<mailto:shurajitdu...@gmail.com>] Sent: Monday, January 01, 2018 6:22 PM To: Spratt, Jennifer <spr...@rti.org<mailto:spr...@rti.org>> Cc: dhis1-users <dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net>>; Preston, Adam <apres...@rti.org<mailto:apres...@rti.org>>; Pavluck, Alexandre <apavl...@rti.org<mailto:apavl...@rti.org>>; Alexander, Keely <kalexan...@rti.org<mailto:kalexan...@rti.org>>; Kochetkova, Emily <ekochetk...@rti.org<mailto:ekochetk...@rti.org>> Subject: Re: [Dhis2-users] Constructing indicators from boolean data elements Hi Jennifer In order to do this you should create two program indicators. 1. Count events with the yes responses 2. Count the total events You can then make a combined indicator in the maintenance indicator app using these two program indicators. To do this choose 'programs' followed by program indicators when you select the numerator/denominator Nick On Jan 1, 2018 6:16 PM, "Spratt, Jennifer" <spr...@rti.org<mailto:spr...@rti.org>> wrote: Hello all, I am trying to create an indicator that is the proportion of entities that replied “yes” on a Boolean data element in a dataset. (Number replying yes divided by total number responding). I have searched high and low in the DHIS2 user’s guide, but find nothing to help me construct what should be a pretty basic indicator. I have specified the Indicator type as “percentage”, the numerator as #{UID}==1 and the denominator as #{UID}>=0, (replacing “UID” with the actual UID of course) and I KNOW there are both 1s and 0s in the data element in question, but the result is always “0”. Also, I thought one could use an indicator as the basis for another indicator, but am unable to see “indicator” among the choice of items when creating numerators and denominators… PS, I have also tried +(#{UID}==1) and #{UID}==”TRUE” as the numerator, but the result is the same… Evidently filters do not work in aggregate indicator construction? Or do they? Could you enlighten me as to what I may be doing wrong, and ideally, point me to the elegant obvious solution? Much obliged, Jennifer E. Spratt, Ph.D. Senior Education Research Analyst International Development Group at RTI International Email: spr...@rti.org<mailto:spr...@rti.org> Skype: j_spratt Mobile: 443-562-2129<tel:(443)%20562-2129> Messages: 410-235-0019<tel:(410)%20235-0019> _______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp -- Jason P. Pickering email: jason.p.picker...@gmail.com<mailto:jason.p.picker...@gmail.com> tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp