dhis2-users team mailing list archive
-
dhis2-users team
-
Mailing list archive
-
Message #14903
Constructing indicators from boolean data elements
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 Messages: 410-235-0019
Follow ups