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
In order to do this you should create two program indicators.
Count events with the yes responses
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@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
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
In order to do this you should create two program indicators.
Count events with the yes responses
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@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
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@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
Subject: Re: [Dhis2-users] Constructing indicators from boolean data elements
Hi Jennifer
In order to do this you should create two program indicators.
Count events with the yes responses
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@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
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
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@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
Subject: Re: [Dhis2-users] Constructing indicators from boolean data elements
Hi Jennifer
In order to do this you should create two program indicators.
Count events with the yes responses
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@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