dhis2-users team mailing list archive
-
dhis2-users team
-
Mailing list archive
-
Message #14905
Re: Constructing indicators from boolean data elements
-
To:
Shurajit Dutta <shurajitdutta@xxxxxxxxx>
-
From:
"Spratt, Jennifer" <spratt@xxxxxxx>
-
Date:
Tue, 2 Jan 2018 00:01:04 +0000
-
Accept-language:
en-US
-
Authentication-results:
spf=none (sender IP is ) smtp.mailfrom=spratt@xxxxxxx;
-
Cc:
dhis1-users <dhis2-users@xxxxxxxxxxxxxxxxxxx>, "Alexander, Keely" <kalexander@xxxxxxx>, "Kochetkova, Emily" <ekochetkova@xxxxxxx>, "Preston, Adam" <apreston@xxxxxxx>, "Pavluck, Alexandre" <apavluck@xxxxxxx>
-
In-reply-to:
<CAMVJAvq_f+iD8veWqaaSVo8Uh9V+5iVLPt2n+d+TOKMC+7q6Gg@mail.gmail.com>
-
Spamdiagnosticmetadata:
NSPM
-
Spamdiagnosticoutput:
1:99
-
Thread-index:
AdODN2vcKiMpedIAT8OqeF4t+KnTDwAH+ZyAAAFMygA=
-
Thread-topic:
[Dhis2-users] Constructing indicators from boolean data elements
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]
Sent: Monday, January 01, 2018 6:22 PM
To: Spratt, Jennifer <spratt@xxxxxxx>
Cc: dhis1-users <dhis2-users@xxxxxxxxxxxxxxxxxxx>; Preston, Adam <apreston@xxxxxxx>; Pavluck, Alexandre <apavluck@xxxxxxx>; Alexander, Keely <kalexander@xxxxxxx>; Kochetkova, Emily <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
Follow ups
References