dhis2-users team mailing list archive

["Spratt, Jennifer" <spratt@xxxxxxx>]

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: spratt@xxxxxxx<mailto:spratt@xxxxxxx>   Skype: j_spratt
Mobile: 443-562-2129  Messages: 410-235-0019

From: Jason Pickering [mailto:jason.p.pickering@xxxxxxxxx]
Sent: Tuesday, January 02, 2018 1:59 AM
To: Spratt, Jennifer <spratt@xxxxxxx>
Cc: Shurajit Dutta <shurajitdutta@xxxxxxxxx>; dhis1-users <dhis2-users@xxxxxxxxxxxxxxxxxxx>; Alexander, Keely <kalexander@xxxxxxx>; Kochetkova, Emily <ekochetkova@xxxxxxx>; Preston, Adam <apreston@xxxxxxx>; Pavluck, Alexandre <apavluck@xxxxxxx>
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 <spratt@xxxxxxx<mailto:spratt@xxxxxxx>> 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: spratt@xxxxxxx<mailto:spratt@xxxxxxx>   Skype: j_spratt
Mobile: 443-562-2129  Messages: 410-235-0019

From: Shurajit Dutta [mailto:shurajitdutta@xxxxxxxxx<mailto:shurajitdutta@xxxxxxxxx>]
Sent: Monday, January 01, 2018 6:22 PM
To: Spratt, Jennifer <spratt@xxxxxxx<mailto:spratt@xxxxxxx>>
Cc: dhis1-users <dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>>; Preston, Adam <apreston@xxxxxxx<mailto:apreston@xxxxxxx>>; Pavluck, Alexandre <apavluck@xxxxxxx<mailto:apavluck@xxxxxxx>>; Alexander, Keely <kalexander@xxxxxxx<mailto:kalexander@xxxxxxx>>; Kochetkova, Emily <ekochetkova@xxxxxxx<mailto:ekochetkova@xxxxxxx>>
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" <spratt@xxxxxxx<mailto:spratt@xxxxxxx>> 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: spratt@xxxxxxx<mailto:spratt@xxxxxxx>   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@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp


_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



--
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx<mailto:jason.p.pickering@xxxxxxxxx>
tel:+46764147049